Post reply

Looking up Table Schema info

  • February 20, 2009 at 9:45 am

    #134929

    I'm running the code below and although it gives me most of the table information I'm looking for, it's not giving me the schema info, such as "dbo", "jdoe", etc. How can I run this script to include the table schema info, or do I need to run something different.

    Selecttop 10 * From Sysobjects where type = 'U'

    thx,

    John

  • February 20, 2009 at 10:11 am

    #947662

    you can use "information_schema.tables" instead!


    * Noel

  • February 20, 2009 at 10:15 am

    #947668

    If you're using sql 2005 (as I assume you are from where this is posted):

    select schema_name(schema_id), name from sys.objects where type='U'

    or

    select schema_name(schema_id),name from sys.tables

  • February 20, 2009 at 12:09 pm

    #947782

    Thanks guys....

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

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