How to Create a database architecture

SQL Server 2008 r2Other Versions

 

This topic describes how to create an architecture. For more information about how to use the architecture, see user architecture separation.

Use SQL Server Management studio to create a schema

1. In SQL Server Management studio, open the object Resource Manager and expand"Database"Folder.

2. Expand the database in which you want to create a new database architecture.

3. Right-click"Security"Folder, pointing"New"And then click"Architecture".

4. In"Regular"Page"Architecture name"Enter the name of the new architecture.

5. In"Architecture owner"Enter the name of the database user or role that you want to own the schema.

6. Click OK ".

Use Transact-SQL to create a schema

1. In the query Editor, run the following Transact-SQL command to connect to the database in which you want to create a new database architecture:

   Use <Database Name> go

2. Run the following Transact-SQL command to create a user:

   Create schema <new schema Name> authorization [new schema owner]; go

   References: http://www.uol123.com/