Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.

How to prevent certain new lines?

morphiaxmorphiax Posts: 2
edited June 13, 2016 5:10AM in SQL Prompt
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?

Comments

  • Ali DAli D Posts: 56 New member
    Hi

    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
Sign In or Register to comment.