When SQL reserved words are used in any of the SQL objects, a component created with Table Generator will fail with a syntax error.
System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'rollback'.
SQL reserved words require placing brackets or quotes around them.
'Add brackets to table name' option can be used specifically for table names and 'Use Quoting' option can be used for column names to avoid syntax errors during component execution.
Below is an example screenshot of how this can be configured in Table generator wizard.
The list of SQL reserved words can be found in the link below:
Subscribing will provide email updates when this Article is updated. Login is required.