title
sys.securable_classes (Transact-SQL)
description
sys.securable_classes (Transact-SQL)
author
VanMSFT
ms.author
vanto
ms.date
12/01/2016
ms.prod
sql
ms.prod_service
database-engine, sql-database, synapse-analytics, pdw
ms.technology
system-objects
ms.topic
reference
f1_keywords
securable_classes_TSQL
securable_classes
sys.securable_classes_TSQL
sys.securable_classes
helpviewer_keywords
sys.securable_classes catalog view
dev_langs
ms.assetid
ae2bf589-17be-4cad-b5d5-05a34173b32d
monikerRange
>=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current
sys.securable_classes (Transact-SQL)
[!INCLUDE sql-asdb-asdbmi-asa-pdw ]
Returns a list of securable classes
Column name
Data type
Description
class_desc
sysname
Name of the class.
class
int
Numerical designation of the class.
[!INCLUDEssCatViewPerm ] For more information, see Metadata Visibility Configuration .
The following example returns the securable classes supported by this instance of [!INCLUDEssNoVersion ].
SELECT * FROM sys .securable_classes ORDER BY class;
Securables