SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
This topic has not yet been rated - Rate this topic

Key_ID (Transact-SQL)

SQL Server 2008 R2

Returns the ID of a symmetric key in the current database.

Topic link icon Transact-SQL Syntax Conventions

Copy 

Key_ID ( 'Key_Name' )
'Key_Name'

The name of a symmetric key in the database.

The name of a temporary key must start with a number sign (#).

Because temporary keys are only available in the session in which they are created, no permissions are required to access them. To access a key that is not temporary, the caller needs some permission on the key and must not have been denied VIEW permission on the key.

A. Returning the ID of a symmetric key

The following example returns the ID of a key called ABerglundKey1.

Copy 
SELECT KEY_ID('ABerglundKey1')

B. Returning the ID of a temporary symmetric key

The following example returns the ID of a temporary symmetric key. Note that # is prepended to the key name.

Copy 
SELECT KEY_ID('#ABerglundKey2')
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.