Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
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.