No GUI display of schemas in the database, right?

• Lowell

  SSC Guru

  Points: 323518

  More actions

  May 17, 2010 at 12:05 pm

  #139077

  There is No GUI display of schemas in the database, right?

  on another post, the topic revolved around renaming a object that had a schema;

  i created a couple of schemas so i could copy some tables, no big deal:

  CREATE SCHEMA bob;

  GO

  CREATE SCHEMA tom;

  GO

  i went to object explorer in SSMS, and can see any objects i created with the schema, ie a table named 'bob.Test', but there's no place int he GUI to see the list of schemas themseleves...i had to query them instead. I half expected to see the "tom" schema with no objects under it.

  someone just confirm what i thought, or am i missing something in the SSMS GUI? We can only see the schemas by querying sys.schemas?

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• Richard M.

  SSCertifiable

  Points: 7401

  More actions

  May 17, 2010 at 12:28 pm

  #1168408

  In SSMS in the Database where you created the Schema, go to Security-->Schemas

  _______________________________________________________________________
  For better assistance in answering your questions, click here[/url]