Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - "CREATE SCHEMA" - Creating a New Schema in a Database

By: FYIcenter.com

(Continued from previous topic...)

How To Create a New Schema in a Database?

If you want to create a new schema in an existing database, you can use the "CREATE SCHEMA" statement as shown in the tutorial example below:

USE FyiCenterData;
GO

CREATE SCHEMA fyi; 
GO
Command(s) completed successfully.

A new schema called "fyi" has been created in "FyiCenterData" database. "fyi" is an empty schema at this moment since no objects has been moved into "fyi" yet.

(Continued on next topic...)

  1. What Is a Schema in SQL Server 2005?
  2. How To Create a New Schema in a Database?
  3. How To List All Schemas in a Database?
  4. How To Create a New Table in a Given Schema?
  5. How To Transfer an Existing Table from One Schema to Another Schema?
  6. How To List All Objects in a Given Schema?
  7. What Is the Default Schema of Your Login Session?
  8. Who Is the Owner of a Schema?
  9. How To Change the Ownership of a Schema?
  10. What Happens If You Are Trying to Access a Schema Not Owned by You?
  11. How To Drop an Existing Schema?

Related Articles:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...