MS SQL Server Specific Preferences

Previous  Top  Next

Below is explanation of the MS SQL Server specific preferences available in Database Workbench:





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.