|
 This page controls
scripting of names. Note that starting in version 1.95, the
settings were somewhat simplified.
For database objects that
have an owner (SQL 7.0, SQL2000) or belong to a named schema
(SQL2005) the Diff would normally determine if it the owner name
must be scripted or just the object name is sufficient. This is the
"Automatic..."
name scripting setting. If you tell the Diff to
"Force
owner names..." then it will always
include them in the script. This applies both to the
display in the
Schema View and to the names in
generated scripts.
MS SQL Server supports
two styles of "quoting"
identifiers which contain
non-alphanumeric characters: by using square brackets [] or by
using double-quotes. The latter may be easily confused, both by the
programmer and the server, with the way you represent string
literals (either with double or single quotes). The Diff allows you
to use either style of notation and here is where you can choose
it.
Normally, the Diff would
only put the quotes or brackets where they are needed, which leads
to more compact and readable SQL. The quoting is needed around
names that contain spaces, any other special or local characters,
or can be confused for a reserved word.
By checking the
Quote
all option you can force it
to quote all identifiers, just like MS Query Analyzer
does.
|
