| title | Objects Supported by the Generate Scripts Wizard |
|---|---|
| ms.custom | seo-lt-2019 |
| ms.date | 03/01/2017 |
| ms.prod | sql |
| ms.technology | scripting |
| ms.reviewer | |
| ms.topic | conceptual |
| ms.assetid | 071eb2cb-f073-41ca-9f4d-11d3b8803495 |
| author | markingmyname |
| ms.author | maghan |
| monikerRange | >=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] 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 | 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.