Post reply

Retrieving VIEW Metadata

  • 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

  • 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

  • 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

  • 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?

    😎

  • 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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply