INSERT INTO format

Gian

Is it possible to specify the format of the auto-inserted code of the INSERT INTO statement so that the field names are all on the same line?
Like this:
INSERT INTO Table (Field1, Field2, Field3)
VALUES (Value1, Value2, Value)

Dan_J

Hi @Gian

Thanks for reaching out to us regarding this.

The best way to achieve this is to create a new Style (SQL Prompt > Active Style > Edit Style) and, under the INSERT options, set 'Place subsequent columns on new lines' to 'Never', and select the desired brackets layout, as show in the screenshot below. You will need to do this for both the Column list and the Values list.

Gian

Hi Dan.
That's wonderful!
Grazie

Ciao