Skip to content

sys-securable-classes-transact-sql.md

Latest commit

 

History

History
54 lines (46 loc) · 1.78 KB

sys-securable-classes-transact-sql.md

File metadata and controls

54 lines (46 loc) · 1.78 KB

title: "sys.securable_classes (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "12/01/2016" ms.prod: "sql" 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:

  • "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:
  • "securable_classes_TSQL"
  • "securable_classes"
  • "sys.securable_classes_TSQL"
  • "sys.securable_classes" dev_langs:
  • "TSQL" 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" monikerRange: ">= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || = sqlallproducts-allversions"

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.

Permissions

[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.

Examples

The following example returns the securable classes supported by this instance of [!INCLUDEssNoVersion].

SELECT * FROM sys.securable_classes ORDER BY class;

See Also

Securables