ScriptOption 속성

보호된 멤버 포함
상속된 멤버 포함

ScriptOption 유형에서 다음 멤버를 표시합니다.

속성

  이름 설명
공용 속성정적 멤버 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 or sets the Boolean property value that specifies whether the security identifiers are included for any scripted logins 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 batch terminator of the script option.
공용 속성정적 멤버 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 schema of the script option.
공용 속성정적 멤버 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.

맨 위로 이동

참고 항목

참조

ScriptOption 클래스

Microsoft.SqlServer.Management.Smo 네임스페이스