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.