Where is "sys.symmetric_keys"

• Barkingdog

  SSCoach

  Points: 18670

  More actions

  December 2, 2005 at 4:29 pm

  #111835

  The BOL example on "Simple Symmetric Encrpytion" begins with

   

  IF NOT EXISTS

  ( SELECT * FROM sys.symmetric_keys WHERE...)

   

  The select statement works fine but where is the referenced "table" to be found? I coulnd't locate it under table\view for the AdventureWorks database or master database.

   

  TIA,

   

  Bill

   

• peterhe

  SSChampion

  Points: 11469

  More actions

  December 7, 2005 at 9:29 am

  #608204

  it's a catalog view under Views-->System Views under each database.