| |
Name
|
Description
|
|---|
|
AgentAlertJob
| Gets or sets the Boolean property that specifies whether to include SQL Server Agent job name for alert objects in the script. |
|
|
AgentJobId
| Gets or sets the Boolean property that specifies whether to include SQL Server Agent job ID values for alert objects in the script. |
|
|
AgentNotify
| Gets or sets the Boolean property that specifies whether to include notifications for any SQL Server Agent alerts that in the script. |
|
|
AllowSystemObjects
| Gets or sets the Boolean property that specifies whether system objects can be scripted or not. |
|
|
AnsiFile
| Gets or sets the Boolean property that specifies whether the script uses multibyte characters and requires code page 1252 to evaluate characters meaning. |
|
|
AnsiPadding
| Gets or sets a Boolean property that specifies whether the generated script contains the Transact-SQL statements SET ANSI-PADDING ON and SET ANSI-PADDING OFF before and after the CREATE TABLE statement respectively. |
|
|
AppendToFile
| Gets or sets a Boolean property value that specifies whether the script is appended to the end of the output file or overwrites it. |
|
|
Bindings
| Gets or sets a Boolean property value that specifies whether the binding statements sp_binddefault and sp_bindrule are included in the generated script. This property applies only when scripting a Microsoft SQL Server table. |
|
|
ClusteredIndexes
| Gets or sets a Boolean property value that specifies whether statements that define clustered indexes are included in the generated script. |
|
|
ContinueScriptingOnError
| Gets or sets the Boolean property value that specifies whether the scripting operation continues after an error is encountered. |
|
|
ConvertUserDefinedDataTypesToBaseType
| Gets or sets the Boolean property value that specifies whether user-defined data types are converted to the most appropriate Microsoft SQL Server base data types in the generated script. |
|
|
DdlBodyOnly
| Gets or sets the Boolean property value that specifies whether to script only the text definition for data definition language (DDL) objects that have a text body, such as stored procedures and triggers. |
|
|
DdlHeaderOnly
| Gets or sets the Boolean property value that specifies whether to script only the header information for data definition language (DDL) objects that have a text body, such as stored procedures and triggers. |
|
|
Default
| Gets or sets the Boolean property value that specifies whether the creation of the referenced object is included in the generated script. |
|
|
DriAll
| Gets or sets the Boolean property value that specifies whether all DRI objects are included in the generated script. |
|
|
DriAllConstraints
| Gets or sets the Boolean property value that specifies whether all DRI constraints are included in the generated script. |
|
|
DriAllKeys
| Gets or sets the Boolean property value that specifies whether the dependency relationships defined by all DRI keys are included in the generated script. |
|
|
DriChecks
| Gets or sets the Boolean property value that specifies whether column specific dependency relationships defined in check constraints with enforced declarative referential integrity are included in the script. |
|
|
DriClustered
| Gets or sets the Boolean property value that specifies whether dependency relationships defined in clustered indexes with enforced declarative referential integrity are included in the script. |
|
|
DriDefaults
| Gets or sets the Boolean property value that specifies whether dependency relationships defined in defaults with enforced declarative referential integrity are included in the script. |
|
|
DriForeignKeys
| Gets or sets the Boolean property value that specifies whether dependency relationships defined in foreign keys with enforced declarative referential integrity are included in the script. |
|
|
DriIncludeSystemNames
| Gets or sets the Boolean property value that specifies whether the system generated constraint names used to enforce declarative referential integrity are included in the script. |
|
|
DriIndexes
| Gets or sets the Boolean property value that specifies whether PRIMARY KEY constraints using a unique index to implement the declarative referential integrity are included in the script. |
|
|
DriNonClustered
| Gets or sets the Boolean property value that specifies whether dependency relationships defined in non-clustered indexes with enforced declarative referential integrity are included in the script. |
|
|
DriPrimaryKey
| Gets or sets the Boolean property value that specifies whether dependency relationships defined in primary keys with enforced declarative referential integrity are included in the script. |
|
|
DriUniqueKeys
| Gets or sets the Boolean property value that specifies whether dependency relationships defined in unique keys with enforced declarative referential integrity are included in the script. |
|
|
DriWithNoCheck
| Gets or sets the Boolean property value that specifies whether the no check statement is included in the script. |
|
|
Encoding
| Gets or sets the encoding for the scripting options. |
|
|
EnforceScriptingOptions
| Gets or sets the Boolean property value that specifies whether the application of all scripting options is enforced for text-based objects, such as SchemaQualify. |
|
|
ExtendedProperties
| Gets or sets the Boolean property value that specifies whether extended object properties are included in the generated script. |
|
|
FileName
| Gets or sets the name of the file to which the generated script is output. |
|
|
FullTextCatalogs
| Gets or sets the Boolean property value that specifies whether full-text catalogs are included in the generated script. |
|
|
FullTextIndexes
| Gets or sets the Boolean property value that specifies whether full-text indexes are included in the generated script. |
|
|
IncludeDatabaseContext
| Gets or sets the Boolean property value that specifies whether the database context is included in the generated script. |
|
|
IncludeHeaders
| Gets or sets a Boolean property value that specifies whether the generated script is prefixed with a header containing information including the date and time of generation. |
|
|
IncludeIfNotExists
| Gets or sets a Boolean property value that specifies whether to check the existence of an object before including it in the script. |
|
|
Indexes
| Gets or sets the Boolean property value that specifies whether indexes are included in the generated script. |
|
|
LoginSid
| Gets or sets the Boolean property value that specifies whether the security identifiers are included for any scripted logins in the generated script. |
|
|
NoAssemblies
| Gets or sets the Boolean property value that specifies whether assemblies are included in the generated script. |
|
|
NoCollation
| Gets or sets the Boolean property value that specifies whether to include the collection in the generated script if the server is running SQL Server 7.0 or later. |
|
|
NoCommandTerminator
| Gets or sets the Boolean property value that specifies whether individual Transact-SQL statements are delimited in the generated script. |
|
|
NoExecuteAs
| Gets or sets the Boolean property value that specifies whether the EXECUTE AS options for stored procedures and user-defined functions are included in the script. |
|
|
NoFileGroup
| Gets or sets the Boolean property value that specifies whether to include the 'ON <filegroup>' clause in the generated script. |
|
|
NoIdentities
| Gets or sets the Boolean property value that specifies whether definitions of identity property seed and increment are included in the generated script. |
|
|
NoIndexPartitioningSchemes
| Gets or sets the Boolean property value that specifies whether partition schemes for indexes are included in the generated script. |
|
|
NoMailProfileAccounts
| Gets or sets the Boolean property value that specifies whether mail accounts referenced by mail profiles are included in the generated script. |
|
|
NoMailProfilePrincipals
| Gets or sets the Boolean property value that specifies whether principals referenced by mail profiles are included in the generated script. |
|
|
NonClusteredIndexes
| Gets or sets the Boolean property value that specifies whether non-clustered indexes are included in the generated script. |
|
|
NoTablePartitioningSchemes
| Gets or sets the Boolean property value that specifies whether partition schemes for tables are included in the generated script. |
|
|
NoViewColumns
| Gets or sets the Boolean property value that specifies whether to include the specified columns for a view. |
|
|
NoXmlNamespaces
| Gets or sets the Boolean property value that specifies whether XML namespaces are included in the generated script. |
|
|
OptimizerData
| Gets or sets the Boolean property value that specifies whether script optimizer data for the referenced objects are included in the generated script. |
|
|
Permissions
| Gets or sets the Boolean property value that specifies whether to all permissions in the generated script. |
|
|
PrimaryObject
| Gets or sets the Boolean property value that specifies whether the creation of the referenced object is included in the generated script. |
|
|
SchemaQualify
| Gets or sets the Boolean property value that specifies whether objects with no schema are included in the generated script. |
|
|
SchemaQualifyForeignKeysReferences
| Gets or sets the Boolean property value that specifies whether schema qualify table references for foreign key constraints are included in the generated script. |
|
|
ScriptDrops
| Gets or sets the Boolean property value that specifies whether the script operation generates a Transact-SQL script to remove the referenced component. |
|
|
Statistics
| Gets or sets the Boolean property value that specifies whether statistics for any table or view that is included in the generated script. |
|
|
TargetServerVersion
| Gets or sets the version of the instance of SQL Server for which the generated script is intended. |
|
|
TimestampToBinary
| Gets or sets the Boolean property value that specifies whether to convert timestamp data types to a binary(8) data types when scripting the creation of a table or user defined data type. |
|
|
ToFileOnly
| Gets or sets the Boolean property value that specifies whether to output to file only or to generate string output also. |
|
|
Triggers
| Gets or sets the Boolean property value that specifies whether to include the definition for triggers in the generated script. |
|
|
WithDependencies
| Gets or sets the Boolean property value that specifies whether to include all dependent objects in the generated script. |
|
|
XmlIndexes
| Gets or sets the Boolean property value that specifies whether XML indexes are included in the generated script. |
