Add column names to VALUES list for INSERT INTO statement generation
When generating the INSERT INTO statement after typing INSERT INTO [TableName] and hitting tab, it would be helpful in the VALUES list, in addition to showing the default value, if the column name was included. For example -
INSERT INTO Users
VALUES (DEFAULT /ID/, '' /FirstName/, '' /LastName/)
This way, for wide tables, you don't have to count column to keep track of which column you are working with.
-
AdminDevart (_, Devart) commented
Hi,
Thanks for your patience!
Please be informed that you can insert all columns when pressing Tab.
Best,
Devart Support Team
-
yair commented
it would be better to change default format to new row for each value and field.