Objects Supported by the Generate Scripts Wizard

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

Supported Objects

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

Application role Database role Schema User-defined aggregate View*
Assembly DEFAULT constraint Stored procedure* User-defined data type XML schema collection
CHECK constraint Full-text catalog Synonym User-defined function
CLR (common language runtime) stored procedure* Index Table User-defined table
CLR user-defined function Rule User** User-defined type

*Published without encryption.

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