Retrieving VIEW Metadata

• Angelindiego

  SSCertifiable

  Points: 6048

  More actions

  October 28, 2015 at 2:12 pm

  #304635

  Has anyone needed to know the metadata of a view?? I need to get that info for SEVERAL views in my database. Is there a fast/easy way of getting this info????? :w00t:

  TIA, Angelindiego

  ---

  Thank you!!,

  Angelindiego
  

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  October 28, 2015 at 2:42 pm

  #1836212

  Try querying:

  sys.views

  sys.sql_modules

  sys.columns

  What specific metadata do you need?

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2

• Angelindiego

  SSCertifiable

  Points: 6048

  More actions

  October 28, 2015 at 4:46 pm

  #1836226

  I ended up using INFORMATON_SCHEMA.COLUMNS. I needed what info I gleaned from that view. Thank you so much for responding!!!

  ---

  Thank you!!,

  Angelindiego
  

• Eirikur Eiriksson

  SSC Guru

  Points: 182948

  More actions

  October 28, 2015 at 4:59 pm

  #1836228

  Angelindiego (10/28/2015)

  ---

  I ended up using INFORMATON_SCHEMA.COLUMNS. I needed what info I gleaned from that view. Thank you so much for responding!!!

  Quick question, Luis's suggestion points to the same source as the limited ANSI compatibility view (INFORMATION_SCHEMA), why use that when the other give more comprehensive information?

  

• Angelindiego

  SSCertifiable

  Points: 6048

  More actions

  October 28, 2015 at 8:09 pm

  #1836242

  I am going to check his suggestion as well (tomorrow). Only reason is that I had "already" done it.....

  ---

  Thank you!!,

  Angelindiego