How to prevent certain new lines?
morphiax
Posts: 2
If I have the following query:
CREATE TABLE Test
(
Test VARCHAR(1020) COLLATE DATABASE_DEFAULT NULL
);
When I format it, it becomes:
CREATE TABLE Test
(
Test VARCHAR(1020) COLLATE DATABASE_DEFAULT
NULL
);
No matter what settings I toggle, it always puts the NULL on a new line. How can I prevent that from happening?
CREATE TABLE Test
(
Test VARCHAR(1020) COLLATE DATABASE_DEFAULT NULL
);
When I format it, it becomes:
CREATE TABLE Test
(
Test VARCHAR(1020) COLLATE DATABASE_DEFAULT
NULL
);
No matter what settings I toggle, it always puts the NULL on a new line. How can I prevent that from happening?
Comments
Unfortunately it’s not possible to stop the NULL getting pushed to the next line with SQL Prompt’s current formatting system. However, we’re quite close to finishing a much more powerful formatting system which will support the formatting you want for your example statement. This new formatting system will be released in the next SQL Prompt beta. Sorry for the delay.
Thanks
Ali