Export (0) Print
Expand All

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.

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

View1

Assembly

DEFAULT constraint

Stored procedure1

User-defined data type

XML schema collection

CHECK constraint

Full-text catalog

Synonym

User-defined function

CLR (common language runtime) stored procedure1

Index

Table

User-defined table

CLR user-defined function

Rule

User2

User-defined type

1 Published without encryption.

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft