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