Below is explanation of the MS SQL Server specific preferences available in Database Workbench:
Option |
Description |
Use uppercase identifiers by default |
Check this option if you want uppercase identifiers to be enabled, by default, for each new database. |
Show object owner |
Checking this options shows the object owner for objects when connected to MS SQL Server 7 & 2000. |
Use brackets instead of quotes |
By default, Database Workbench will use the ANSI SQL standard object name specifier, the "double quote". If the connected database does not support this or if this option is checked, the "square brackets" will be used instead. |
Default Isolation |
The default transaction isolation used in the SQL/Script Editor. |