title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.securable_classes (Transact-SQL) |
sys.securable_classes (Transact-SQL) |
VanMSFT |
vanto |
12/01/2016 |
sql |
system-objects |
reference |
|
|
|
>=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current||=fabric |
[!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;