Post reply

schema view in sql server

  • May 15, 2012 at 7:10 am

    #274079

    Hi

    Is there a way of viewing the tables in management studio by schema?

    Id like to be able to expand and collapse schemas to limit the number of tables i am looking at.

    Probly a simple question and i probably cant see the woods for the trees.

    Thanks in advance

  • May 15, 2012 at 7:26 am

    #1487665

    you could try a

    SELECT * FROM [sys].[tables]

    where schema_id = 'your_schema_id'

  • May 15, 2012 at 7:36 am

    #1487676

    erics44 (5/15/2012)

    Hi

    Is there a way of viewing the tables in management studio by schema?

    Id like to be able to expand and collapse schemas to limit the number of tables i am looking at.

    Probly a simple question and i probably cant see the woods for the trees.

    Thanks in advance

    In Object Explorer you can filter the tables, view, etc by filtering on schema.

  • May 15, 2012 at 7:40 am

    #1487683

    I've never attempted it myself, but you could try writing a custom report that you invoke by right-clicking on Tables and choosing Reports -> Custom Reports.

    John

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

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