Wiki Home

SQL DMOScript


Namespace: DotNet
* SQLDMOScript.h
#DEFINE SQLDMOScript_AppendToFile 256 && Object Script method only. Append to indicated output file. By default, Script method overwrites existing file.
#DEFINE SQLDMOScript_Bindings 128 && Generate sp_bindefault and sp_bindrule statements. Applies only when scripting references a SQL Server table.
#DEFINE SQLDMOScript_ClusteredIndexes 8 && Generate Transact-SQL defining clustered indexes. Applies only when scripting references a SQL Server table.
#DEFINE SQLDMOScript_DRIIndexes 65536 && When SQLDMOScript_NoDRI is specified, script PRIMARY KEY constraints using a unique index to implement the declarative referential integrity. Applies only when scripting references a SQL Server table.
#DEFINE SQLDMOScript_DRIWithNoCheck 536870912 && When using SQLDMOScript_DRI_Checks, or SQLDMOScript_DRI_ForeignKeys, generated script includes the WITH NOCHECK clause optimizing constraint creation. Applies only when scripting references a SQL Server table.
#DEFINE SQLDMOScript_DRI_All 532676608 && All values defined as SQLDMOScript_DRI_... combined using an OR logical operator.
#DEFINE SQLDMOScript_DRI_AllConstraints 520093696 && SQLDMOScript_DRI_Checks, SQLDMOScript_DRI_Defaults, SQLDMOScript_DRI_ForeignKeys, SQLDMOScript_DRI_PrimaryKey, and SQLDMOScript_DRI_UniqueKeys combined using an OR logical operator.
#DEFINE SQLDMOScript_DRI_AllKeys 469762048 && SQLDMOScript_DRI_ForeignKeys, SQLDMOScript_DRI_PrimaryKey, SQLDMOScript_DRI_UniqueKeys combined using an OR logical operator.
#DEFINE SQLDMOScript_DRI_Checks 16777216 && Generated script creates column-specified CHECK constraints. Directs scripting when declarative referential integrity establishes dependency relationships. Applies only when scripting references a SQL Server table.
#DEFINE SQLDMOScript_DRI_Clustered 8388608 && Generated script creates clustered indexes. Directs scripting when declarative referential integrity establishes dependency relationships. Applies only when scripting references a SQL Server table.
#DEFINE SQLDMOScript_DRI_Defaults 33554432 && Generated script includes column-specified defaults. Directs scripting when declarative referential integrity establishes dependency relationships. Applies only when scripting references a SQL Server table.
#DEFINE SQLDMOScript_DRI_ForeignKeys 134217728 && Generated script creates FOREIGN KEY constraints. Directs scripting when declarative referential integrity establishes dependency relationships. Applies only when scripting references a SQL Server table.
#DEFINE SQLDMOScript_DRI_NonClustered 4194304 && Generated script creates nonclustered indexes. Directs scripting when declarative referential integrity establishes dependency relationships. Applies only when scripting references a SQL Server table.
#DEFINE SQLDMOScript_DRI_PrimaryKey 268435456 && Generated script creates PRIMARY KEY constraints. Directs scripting when declarative referential integrity establishes dependency relationships. Applies only when scripting references a SQL Server table.
#DEFINE SQLDMOScript_DRI_UniqueKeys 67108864 && Generated script creates candidate keys defined using a unique index. Directs scripting when declarative referential integrity establishes dependency relationships. Applies only when scripting references a SQL Server table.
#DEFINE SQLDMOScript_DatabasePermissions 32 && Generate Transact-SQL database privilege defining script. Database permissions grant or deny statement execution rights.
#DEFINE SQLDMOScript_Default 4 && SQLDMOScript_PrimaryObject.
#DEFINE SQLDMOScript_Drops 1 && Generate Transact-SQL to remove referenced component. Script tests for existence prior attempt to remove component.
#DEFINE SQLDMOScript_IncludeHeaders 131072 && Generated script is prefixed with a header containing date and time of generation and other descriptive information.
#DEFINE SQLDMOScript_IncludeIfNotExists 4096 && Transact-SQL creating a component is prefixed by a check for existence. When script is executed, component is created only when a copy of the named component does not exist.
#DEFINE SQLDMOScript_Indexes 73736 && SQLDMOScript_ClusteredIndexes, SQLDMOScript_NonClusteredIndexes, and SQLDMOScript_DRIIndexes combined using an OR logical operator. Applies to both table and view objects.
#DEFINE SQLDMOScript_NoCommandTerm 32768 && Individual Transact-SQL statements in the script are not delimited using the connection-specific command terminator. By default, individual Transact-SQL statements are delimited.
#DEFINE SQLDMOScript_NoDRI 512 && Generated Transact-SQL statements do not include any clauses defining declarative referential integrity constraints. Applies only when scripting references a SQL Server table. Only use when script will execute on an instance of SQL SERVER version 4.21a.
#DEFINE SQLDMOScript_NoIdentity 1073741824 && Generated Transact-SQL statements do not include definition of identity property, seed, and increment. Applies only when scripting references a SQL Server table.
#DEFINE SQLDMOScript_NonClusteredIndexes 8192 && Generate Transact-SQL defining nonclustered indexes. Applies only when scripting references a SQL Server table.
#DEFINE SQLDMOScript_ObjectPermissions 2 && Include Transact-SQL privilege defining statements when scripting database objects.
#DEFINE SQLDMOScript_OwnerQualify 262144 && Object names in Transact-SQL generated to remove an object are qualified by the owner of the referenced object. Transact-SQL generated to create the referenced object qualify the object name using the current object owner.
#DEFINE SQLDMOScript_Permissions 34 && SQLDMOScript_ObjectPermissions and SQLDMOScript_DatabasePermissions combined using an OR logical operator.
#DEFINE SQLDMOScript_PrimaryObject 4 && Generate Transact-SQL creating the referenced component.
#DEFINE SQLDMOScript_TimestampToBinary 524288 && When scripting object creation for a table or user-defined data type, convert specification of timestamp data type to binary(8).
#DEFINE SQLDMOScript_ToFileOnly 64 && Most SQL-DMO object scripting methods specify both a return value and an optional output file. When used, and an output file is specified, the method does not return the script to the caller, but only writes the script to the output file.
#DEFINE SQLDMOScript_Triggers 16 && Generate Transact-SQL defining triggers. Applies only when scripting references a SQL Server table.
#DEFINE SQLDMOScript_UDDTsToBaseType 1024 && Convert specification of user-defined data types to the appropriate SQL Server base data type. Applies only when scripting references a SQL Server table.
#DEFINE SQLDMOScript_UseQuotedIdentifiers -1 && Use quote characters to delimit identifier parts when scripting object names.

#DEFINE SQLDMOScript2_AgentAlertJob 2048 && Generate Transact-SQL script creating SQLServerAgent service jobs and alerts.
#DEFINE SQLDMOScript2_AgentNotify 1024 && When scripting an alert, generate script creating notifications for the alert.
#DEFINE SQLDMOScript2_AnsiFile 2 && Generated script file uses multibyte characters. Code page 1252 is used to determine character meaning.
#DEFINE SQLDMOScript2_AnsiPadding 1 && Command batch includes Transact-SQL statements SET ANSI_PADDING ON and SET ANSI_PADDDING OFF statements before and after CREATE TABLE statements in the generated script.
#DEFINE SQLDMOScript2_Default 0 && No scripting options specified.
#DEFINE SQLDMOScript2_EncryptPWD 128 && Encrypt passwords with script. When specified, SQLDMOScript2_UnicodeFile must be specified as well.
#DEFINE SQLDMOScript2_ExtendedProperty 4194304 && Include extended property scripting as part of object scripting.
#DEFINE SQLDMOScript2_FullTextCat 2097152 && Command batch includes Transact-SQL statements creating Microsoft Search full-text catalogs.
#DEFINE SQLDMOScript2_FullTextIndex 524288 && Command batch includes statements defining Microsoft Search full-text indexing.
#DEFINE SQLDMOScript2_LoginSID 8192 && Include security identifiers for logins scripted.
#DEFINE SQLDMOScript2_MarkTriggers 32 && Generated script creates replication implementing triggers as system objects. Applies only when scripting replication articles.
#DEFINE SQLDMOScript2_NoCollation 8388608 && Do not script the collation clause if source is later tha SQL Server version 7.0. The default is to generate collation.
#DEFINE SQLDMOScript2_NoFG 16 && Command batch does not include 'ON ' clause that directs filegroup use.
#DEFINE SQLDMOScript2_NoWhatIfIndexes 512 && Command batch does not include CREATE STATISTICS statements.
#DEFINE SQLDMOScript2_UnicodeFile 4 && Generated script output file is a Unicode-character text file.