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