| title | Objects Supported by the Generate Scripts Wizard |
|---|---|
| ms.custom | seo-lt-2019 |
| ms.date | 03/06/2017 |
| ms.prod | sql-server-2014 |
| ms.reviewer | |
| ms.technology | database-engine |
| ms.topic | conceptual |
| ms.assetid | 071eb2cb-f073-41ca-9f4d-11d3b8803495 |
| author | MightyPen |
| ms.author | genemi |
| manager | craigg |
The Generate and Publish Scripts wizard supports a subset of the objects supported by the [!INCLUDEssDEnoversion].
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.