title
sys.securable_classes (Transact-SQL)
description
sys.securable_classes (Transact-SQL)
author
VanMSFT
ms.author
vanto
ms.date
12/01/2016
ms.service
sql
ms.subservice
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
monikerRange
>=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current||=fabric
sys.securable_classes (Transact-SQL)
[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw ]
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