Skip to content

Latest commit

 

History

History
32 lines (26 loc) · 1.26 KB

File metadata and controls

32 lines (26 loc) · 1.26 KB
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

Objects Supported by the Generate Scripts Wizard

The Generate and Publish Scripts wizard supports a subset of the objects supported by the [!INCLUDEssDEnoversion].

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 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.