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!