Membres ScriptOption

The ScriptOption object represents the SQL Server script options that can be included in scripting options that are set by using the ScriptingOptions object.

Le type ScriptOption expose les membres suivants.

Méthodes

	Nom	Description
	Add	Adds two ScriptOption objects to create a ScriptOptions object.
	BitwiseOr	Combines two ScriptingOptions object using a Bitwise OR operation.
	Equals	Returns a Boolean value that specifies if two ScriptOptions are equal. (Se substitue à Object. . :: . .Equals(Object).)
	Finalize	(Hérité de Object.)
	GetHashCode	Returns the hash code for this object. (Se substitue à Object. . :: . .GetHashCode() () () ().)
	GetType	(Hérité de Object.)
	MemberwiseClone	(Hérité de Object.)
	ToString	Returns a string that represents the current object. (Se substitue à Object. . :: . .ToString() () () ().)

Haut de la page

Opérateurs

	Nom	Description
	Addition	Creates a set of scripting options by performing an addition operation on two ScriptOption objects.
	BitwiseOr	Creates a set of scripting options by performing a bitwise OR operation on two ScriptOption objects.
	Implicit Widening Implicit Implicit Implicit(ScriptOption to ScriptingOptions)

Haut de la page

Propriétés

	Nom	Description
	AgentAlertJob	Gets an object that specifies whether to include SQL Server Agent alerts and jobs in the script.
	AgentJobId	Gets an object that specifies whether to include SQL Server Agent alerts and jobs in the script.
	AgentNotify	Gets an object that specifies whether to include notifications for any SQL Server Agent alerts that in the script.
	AllowSystemObjects	Gets an object that specifies whether system objects can be scripted or not.
	AnsiFile	Gets an object that specifies whether the script uses multibyte characters and requires code page 1252 to evaluate characters meaning.
	AnsiPadding	Gets an object 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 an object that specifies whether the script is appended to the end of the output file or overwrites it.
	Bindings	Gets an object 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.
	ChangeTracking	Gets the ChangeTracking property value.
	ClusteredIndexes	Gets an object that specifies whether statements that define clustered indexes are included in the generated script.
	ContinueScriptingOnError	Gets an object value that specifies whether the scripting operation continues after an error is encountered.
	ConvertUserDefinedDataTypesToBaseType	Gets an object value that specifies whether user-defined data types are converted to the most appropriate SQL Server base data types in the generated script.
	DdlBodyOnly	Gets an object 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 an object 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 an object value that specifies whether the creation of the referenced object is included in the generated script.
	DriAll	Gets an object value that specifies whether the DRI objects are included in the generated script.
	DriAllConstraints	Gets an object value that specifies whether all DRI constraints are included in the generated script.
	DriAllKeys	Gets an object value that specifies whether all DRI keys (DriForeignKeys, DriPrimaryKey, DriUniqueKeys) are included in the generated script.
	DriChecks	Gets an object value that specifies whether column-specific dependency relationships defined in check constraints with enforced declarative referential integrity are included in the script.
	DriClustered	Gets an object value that specifies whether dependency relationships defined in clustered indexes with enforced declarative referential integrity are included in the script.
	DriDefaults	Gets an object value that specifies whether dependency relationships defined in defaults with enforced declarative referential integrity are included in the script.
	DriForeignKeys	Gets an object value that specifies whether dependency relationships defined in foreign keys with enforced declarative referential integrity are included in the script.
	DriIncludeSystemNames	Gets an object value that specifies whether the system generated constraint names used to enforce declarative referential integrity are included in the script.
	DriIndexes	Gets an object value that specifies whether PRIMARY KEY constraints using a unique index to implement the declarative referential integrity are included in the generated script.
	DriNonClustered	Gets an object value that specifies whether dependency relationships defined in non-clustered indexes with enforced declarative referential integrity are included in the script.
	DriPrimaryKey	Gets an object value that specifies whether dependency relationships defined in primary keys with enforced declarative referential integrity are included in the script.
	DriUniqueKeys	Gets an object value that specifies whether dependency relationships defined in unique keys with enforced declarative referential integrity are included in the script.
	DriWithNoCheck	Gets an object value that specifies whether the no check statement is included in the script.
	EnforceScriptingOptions	Gets an object value that specifies whether the application of all scripting options is enforced for text base objects, such as SchemaQualify.
	ExtendedProperties	Gets an object value that specifies whether extended object properties are included in the generated script.
	FullTextCatalogs	Gets an object value that specifies whether full-text catalogs are included in the generated script.
	FullTextIndexes	Gets an object value that specifies whether full-text indexes are included in the generated script.
	FullTextStopLists	Gets an object value that specifies whether full-text stop lists are included in the generated script.
	IncludeDatabaseContext	Gets an object value that specifies whether database content is included in the generated script.
	IncludeDatabaseRoleMemberships	Gets the IncludeDatabaseRoleMemberships property value.
	IncludeFullTextCatalogRootPath	Gets the IncludeFullTextCatalogRootPath property value.
	IncludeHeaders	Gets an object that specifies whether the generated script is prefixed with a header containing information including the date and time of generation.
	IncludeIfNotExists	Gets an object that specifies whether to check the existence of an object before including it in the script.
	Indexes	Gets an object that specifies whether indexes are included in the generated script.
	LoginSid	Gets an object value that specifies whether assemblies are included in the generated script.
	NoAssemblies	Gets an object that specifies whether assemblies are excluded from the generated script.
	NoCollation	Gets an object 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 an object value that specifies whether individual Transact-SQL statements are delimited in the generated script.
	NoExecuteAs	Gets an object value that specifies whether the EXECUTE AS options for stored procedures and user-defined functions are included in the script.
	NoFileGroup	Gets an object value that specifies whether to include the 'ON <filegroup>' clause in the generated script.
	NoFileStream	Gets an object that specifies whether to include the FILESTREAM_ON clause when you create VarBinaryMax columns in the generated script.
	NoFileStreamColumn	Gets an object that specifies whether to include the FILESTREAM_ON clause when you create VarBinaryMax columns in the generated script.
	NoIdentities	Gets an object value that specifies whether definitions of identity property seed and increment are included in the generated script.
	NoIndexPartitioningSchemes	Gets an object value that specifies whether partition schemes for indexes are included in the generated script.
	NoMailProfileAccounts	Gets an object value that specifies whether mail accounts referenced by mail profiles are included in the generated script.
	NoMailProfilePrincipals	Gets an object value that specifies whether principals referenced by mail profiles are excluded from the generated script.
	NonClusteredIndexes	Gets an object value that specifies whether non-clustered indexes are included in the generated script.
	NoTablePartitioningSchemes	Gets an object value that specifies whether partition schemes for tables are included in the generated script.
	NoVardecimal	Gets the NoVardecimal property value.
	NoViewColumns	Gets an object value that specifies whether to include the specified columns for a view.
	NoXmlNamespaces	Gets an object value that specifies whether XML namespaces are included in the generated script.
	OptimizerData	Gets an object value that specifies whether script optimizer data for the referenced objects are included in the generated script.
	Permissions	Gets an object value that specifies whether to all permissions in the generated script.
	PrimaryObject	Gets an object value that specifies whether the creation of the referenced object is included in the generated script.
	SchemaQualify	Gets an object value that specifies whether the script contains object with no schema.
	SchemaQualifyForeignKeysReferences	Gets an object value that specifies whether tables with no schema that are referenced by a foreign key are included in the generated script.
	ScriptBatchTerminator	Gets the ScriptBatchTerminator property value.
	ScriptData	Gets the ScriptData property value.
	ScriptDataCompression	Gets an object value that specifies whether the creation of the referenced object is included in the generated script.
	ScriptOwner	Gets an object value that specifies whether the creation of the referenced object is included in the generated script.
	ScriptSchema	Gets the ScriptSchema property value.
	Statistics	Gets an object value that specifies whether statistics are generated for any table or view included in the generated script.
	TimestampToBinary	Gets an object 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 an object value that specifies whether to output to file only or to generate string output too.
	Triggers	Gets an object value that specifies whether to include the definition for triggers in the generated script.
	WithDependencies	Gets an object value that specifies whether to include all dependent objects in the generated script.
	XmlIndexes	Gets an object value that specifies whether XML indexes are included in the generated script.

Haut de la page

Voir aussi

Référence

ScriptOption Classe

Espace de noms Microsoft.SqlServer.Management.Smo