| Name | Description |
| AbandonRemoteDataWhenDisablingArchiving |
Gets or sets the value that indicates whether the remote data should be abandon when the table remote archiving or stretching is disabled.
|
| AddAssemblyToTrustedList |
Gets or sets the value that indicates whether a new assembly should be added to the trusted list when the assembly is created.
It applies to SQL Server 2017 or higher.
|
| AlterScript |
Gets or sets the value that indicates whether the script should ALTER the database entity.
|
| CheckAbsence |
Indicates whether a check for absence should be added to the script that creates an object. This option generates a "IF NOT EXISTS()..." statement.
|
| CheckExistence |
Indicates whether a check for existence should be added to the script that drops an object.
This option generates a "IF EXISTS ()..." statement.
|
| CreateScript |
Gets or sets the value that indicates whether the script should CREATE the database entity.
|
| DropScript |
Gets or sets the value that indicates whether the script should DROP the database entity.
|
| DropSystemVersioningHistoryTable |
Gets or sets the value that indicates whether the history associated with a system-versioned table
should be dropped when the table is dropped or when the table system-versioning is disabled.
|
| RefreshReferencedObjectsOnRebuild |
Indicates whether the table rebuild script should refresh the referenced objects. It applies only to referenced views.
|
| RemoveAssemblyFromTrustedListWhenDropped |
Gets or sets the value that indicates whether the an assembly should be removed from the trusted list when it is dropped from the database.
It applies to SQL Server 2017 or higher.
|
| ScriptAnsiNullsSettings |
Indicates whether the SET ANSI_NULLS setting should be scripted.
|
| ScriptAnsiPaddingSetting |
Indicates whether the SET ANSI_PADDING setting should be scripted.
|
| ScriptBindingToDefault |
Indicates whether the script that binds columns and data types to stand-alone defaults should be generated.
|
| ScriptBindingToRule |
Indicates whether the script that binds columns and data types to rules should be generated.
|
| ScriptCheckConstraint |
Indicates whether the check constraints should be included in the script for a table or table data type.
|
| ScriptCheckConstraintEmbedded |
Indicates whether the script for the check constraint should be generated as an embedded script for a table.
|
| ScriptCheckConstraintsName |
Indicates whether the check constraint name should be included in the embedded script.
This option has no effect when the check constraint is scripted as a stand-alone constraint.
|
| ScriptCollation |
Indicates whether the column collation should be scripted.
|
| ScriptColumnEncryption |
Gets or sets the value that indicates whether the column encryption clause ENCRYPTED WITH (...) should be scripted.
|
| ScriptColumnMask |
Gets or sets the value that indicates whether the column dynamic mask MASKED WITH (...) should be scripted.
|
| ScriptColumnstoreIndexDropExisting |
Indicates whether the DROP_EXISTING option of a columnstore index should be scripted.
|
| ScriptConstraintsWithNoCheck |
Indicates whether a check constrains should be scripted with NOCHECK option.
|
| ScriptDataCompression |
Indicates whether the data compression for a table or index should be scripted.
|
| ScriptDefaultConstraint |
Indicates whether the default constraints should be included in the script for a table or table data type.
|
| ScriptDefaultConstraintEmbedded |
Indicates whether the script for a default constraint should be generated as an embedded script for a table.
|
| ScriptDefaultConstraintsName |
Indicates whether the default constraint name should be included in the embedded script.
This option has no effect when the default constraint is scripted as a stand-alone constraint.
|
| ScriptEdgeConstraints |
Gets or sets the value that indicates whether the edge constraints should be included in the table script.
|
| ScriptExtendedProperties |
Indicates whether the extended properties should be included in the script.
|
| ScriptFileGroup |
Indicates whether the filegroup should be scripted for a table or index.
|
| ScriptForeignKeys |
Indicates whether the foreign keys should be included in the script for a table.
|
| ScriptFullTextCatalogPath |
Indicates whether the full-text catalog script should contain the catalog physical path.
|
| ScriptFullTextIndex |
Indicates whether the full-text indexes should be included in the script for a table or view.
|
| ScriptFullTextStopListWords |
Indicates whether the script should include full-text stop list keywords.
|
| ScriptHistoryRemoteDataArchiving |
Gets or sets the value that indicates whether the remote data archiving of the temporal history table should be scripted.
|
| ScriptIndexes |
Indicates whether the indexes should be included in the script for a table or view.
|
| ScriptIndexFillFactorProperty |
Indicates whether the FILLFACTOR option should be scripted for an index, primary key or unique constraint.
|
| ScriptIndexIgnoreDuplicateKeysProperty |
Indicates whether the IGNORE_DUP_KEY option should be scripted for an index or unique constraint.
|
| ScriptIndexPaddingProperty |
Indicates whether the PAD_INDEX option should be scripted for an index, primary key or unique constraint.
|
| ScriptIndexPageLocksProperty |
Indicates whether the ALLOW_PAGE_LOCKS option should be scripted for an index, primary key or unique constraint.
|
| ScriptIndexRowLocksProperty |
Indicates whether the ALLOW_ROW_LOCKS option should be scripted for an index, primary key or unique constraint.
|
| ScriptIndexStatsNoRecomputeProperty |
Indicates whether the STATISTICS_NORECOMPUTE option should be scripted for an index, primary key and unique constraint.
|
| ScriptMasterKey |
Indicates whether the database master key should be scripted.
|
| ScriptMembershipToRole |
Indicates whether the membership to database roles should be scripted.
|
| ScriptNotForReplication |
Indicates whether the NOT FOR REPLICATION property should be scripted.
|
| ScriptNullability |
Indicates whether the column NULL/NOT NULL property should be scripted.
|
| ScriptOpenMasterKey |
Indicates whether the script should contain the statement that opens the database master key.
|
| ScriptPermissions |
Indicates whether the permissions should be included in the script.
|
| ScriptPrimaryKeys |
Indicates whether the primary key should be included in the script for a table or table data type.
|
| ScriptPrimaryKeysEmbedded |
Indicates whether the primary key script should be generated as an embedded script for a table.
|
| ScriptQuotedIdentifierSetting |
Indicates whether the SET QUOTED_IDENTIFIER setting should be scripted.
|
| ScriptRemoteDataArchiving |
Gets or sets the value that indicates whether the remote data archiving (or stretching) of a table should be scripted.
|
| ScriptSearchPropertyListProperties |
Indicates whether the script should include the properties of search property lists.
|
| ScriptSequenceMaxValue |
Indicates whether sequence max value should be scripted.
|
| ScriptSequenceMinValue |
Indicates whether sequence min value should be scripted.
|
| ScriptSequenceStartValue |
Indicates whether sequence start value should be scripted.
|
| ScriptSpatialIndexes |
Indicates whether the spatial indexes should be included in the script for a table.
|
| ScriptStatistics |
Indicates whether the statistics should be included in the script for a table or view.
|
| ScriptSystemVersioning |
Gets or sets the value that indicates whether the system-versioning for a table should be scripted.
|
| ScriptTableChangeDataCapture |
Indicates whether the table change data capture should be scripted.
|
| ScriptTableChangeTracking |
Indicates whether the table change tracking should be scripted.
|
| ScriptTableLockEscalation |
Indicates whether the table lock escalation property should be scripted.
|
| ScriptTriggers |
Indicates whether the triggers should be included in the script for a table or view.
|
| ScriptUniqueConstraints |
Indicates whether the unique constraints should be included in the script for a table or table data type.
|
| ScriptUniqueConstraintsEmbedded |
Indicates whether the unique constraint script should be generated as an embedded script for a table.
|
| ScriptXmlIndexes |
Indicates whether the xml indexes should be included in the script for a table.
|
| StandardizeNameInDefinition |
Indicates whether the object name in the SQL definition should be formatted as [schema].[name].
This option applies to views, procedures, functions and triggers.
|