sys-credentials-transact-sql.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs	monikerRange
sys.credentials (Transact-SQL)	sys.credentials (Transact-SQL)	VanMSFT	vanto	04/06/2020	sql	system-objects	reference	sys.credentials sys.credentials_TSQL credentials_TSQL credentials	sys.credentials catalog view	TSQL	>=aps-pdw-2016||=azure-sqldw-latest||>=sql-server-2016||>=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)