title
sys.securable_classes (Transact-SQL) | Microsoft Docs
ms.custom
ms.date
12/01/2016
ms.prod
sql-non-specified
ms.prod_service
database-engine, sql-database, sql-data-warehouse, pdw
ms.service
ms.component
system-catalog-views
ms.reviewer
ms.suite
sql
ms.technology
ms.tgt_pltfrm
ms.topic
language-reference
f1_keywords
securable_classes_TSQL
securable_classes
sys.securable_classes_TSQL
sys.securable_classes
dev_langs
helpviewer_keywords
sys.securable_classes catalog view
ms.assetid
ae2bf589-17be-4cad-b5d5-05a34173b32d
caps.latest.revision
16
author
edmacauley
ms.author
edmaca
manager
craigg
ms.workload
Inactive
sys.securable_classes (Transact-SQL)
[!INCLUDEtsql-appliesto-ss2008-all-md ]
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