sys-database-credentials-transact-sql.md

title	sys.database_credentials (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	02/27/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database, sql-data-warehouse
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sys.database_credentials sys.database_credentials_TSQL database_credentials database_credentials_TSQL
helpviewer_keywords	sys.database_credentials catalog view
ms.assetid	796322df-e62a-45bf-b519-89e1d521abce
author	VanMSFT
ms.author	vanto
monikerRange	=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.database_credentials (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2016-asdb-asdw-xxx-md]

Returns one row for each database scoped credential in the database.

Important

[!INCLUDEssNoteDepFutureAvoid] Use sys.database_scoped_credentials instead.

Column name	Data type	Description
credential_id	int	ID of the database scoped credential. Is unique in the database.
name	sysname	Name of the database scoped credential. Is unique in the database.
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 database scoped credential was created.
modify_date	datetime	Time at which the database scoped credential was last modified.
target_type	nvarchar(100)	Type of database scoped credential. Returns NULL for database scoped credentials.
target_id	int	ID of the object that the database scoped credential is mapped to. Returns 0 for database scoped credentials

Permissions

Requires CONTROL permission on the database.

See Also

Credentials (Database Engine)
CREATE DATABASE SCOPED CREDENTIAL (Transact-SQL)
ALTER DATABASE SCOPED CREDENTIAL (Transact-SQL)
DROP DATABASE SCOPED CREDENTIAL (Transact-SQL)
CREATE CREDENTIAL (Transact-SQL)
sys.credentials (Transact-SQL)