Clever Geek Handbook

How to create a schema like .dbo in SQL Server [2005]

I am creating a database in SQL Server 2005 and I cannot remember the "CREATE SCHEMA" statute, if so, create a new schema like ".dbo". I did this last night, but I can't remember how and I can't find the article. What I am trying to accomplish is a database organization like AdventureWorks database where tables are split into: Person.Contact, Person. *, HumanResources.blah, Other.Blah, etc. This is a simple question that I'm sure ... I just can't remember. Thanks in advance!

+2


source to share


1 answer


CREATE SCHEME More details here: http://msdn.microsoft.com/en-us/library/ms189462.aspx



+5


source






More articles:


All Articles