sys-credentials-transact-sql.md

title	sys.credentials (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	04/06/2020
ms.prod	sql
ms.prod_service	database-engine, sql-data-warehouse, pdw
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sys.credentials sys.credentials_TSQL credentials_TSQL credentials
dev_langs	TSQL
helpviewer_keywords	sys.credentials catalog view
ms.assetid	ea48cf80-904a-4273-a950-6d35b1b0a1b6
author	VanMSFT
ms.author	vanto
monikerRange	>=aps-pdw-2016||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.credentials (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-asdbmi-asdw-pdw-md]

Returns one row for each server-level credential.

Column name	Data type	Description
credential_id	int	ID of the credential. Is unique in the server.
name	sysname	Name of the credential. Is unique in the server.
credential_identity	nvarchar(4000)	Name of the identity to use. This will generally be a Windows user. It does not have to be unique.
create_date	datetime	Time at which the credential was created.
modify_date	datetime	Time at which the credential was last modified.
target_type	nvarchar(100)	Type of credential. Returns NULL for traditional credentials, CRYPTOGRAPHIC PROVIDER for credentials mapped to a cryptographic provider. For more information about external key management providers, see Extensible Key Management (EKM).
target_id	int	ID of the object that the credential is mapped to. Returns 0 for traditional credentials and non-0 for credentials mapped to a cryptographic provider. For more information about external key management providers, see Extensible Key Management (EKM).

Remarks

For database-level credentials, see sys.database_scoped_credentials.

Permissions

Requires either VIEW ANY DEFINITION permission or ALTER ANY CREDENTIAL permission. In addition, the principal must not be denied VIEW ANY DEFINITION permission.

See Also

sys.database_scoped_credentials
Credentials (Database Engine)
Security Catalog Views (Transact-SQL)
Principals (Database Engine)
CREATE CREDENTIAL (Transact-SQL)