---
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)
[!INCLUDE[tsql-appliesto-ss2008-asdbmi-asdw-pdw-md](../../includes/tsql-appliesto-ss2008-asdbmi-asdw-pdw-md.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)](../../relational-databases/security/encryption/extensible-key-management-ekm.md).|  
|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)](../../relational-databases/security/encryption/extensible-key-management-ekm.md).|  

## Remarks  
For database-level credentials, see [sys.database_scoped_credentials](../../relational-databases/system-catalog-views/sys-database-scoped-credentials-transact-sql.md).
  
## 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](../../relational-databases/system-catalog-views/sys-database-scoped-credentials-transact-sql.md)   
 [Credentials (Database Engine)](../../relational-databases/security/authentication-access/credentials-database-engine.md)   
 [Security Catalog Views (Transact-SQL)](../../relational-databases/system-catalog-views/security-catalog-views-transact-sql.md)   
 [Principals (Database Engine)](../../relational-databases/security/authentication-access/principals-database-engine.md)   
 [CREATE CREDENTIAL (Transact-SQL)](../../t-sql/statements/create-credential-transact-sql.md)