title
sys.securable_classes (Transact-SQL) | Microsoft Docs
ms.custom
ms.date
12/01/2016
ms.prod
sql-non-specified
ms.reviewer
ms.suite
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
BYHAM
ms.author
rickbyh
manager
jhubbard
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