TechNet
Export (0) Print
Expand All

Objects Supported by the Generate Scripts Wizard

 

Applies To: SQL Server 2016

The Generate and Publish Scripts wizard supports a subset of the objects supported by the SQL Server Database Engine.

The following table lists the objects that can be published supported by the Generate and Publish Scripts Wizard.

Application roleDatabase roleSchemaUser-defined aggregateView*
AssemblyDEFAULT constraintStored procedure*User-defined data typeXML schema collection
CHECK constraintFull-text catalogSynonymUser-defined function
CLR (common language runtime) stored procedure*IndexTableUser-defined table
CLR user-defined functionRuleUser**User-defined type

*Published without encryption.

**Any non-system users that exist in the database are published as Roles.

Community Additions

ADD
Show:
© 2016 Microsoft