MS SQL Server Concepts and Programming Question:
Download Questions PDF

How To Create a New Schema in a Database?

Answer:

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 GlobalGuideLineDatabase;
GO

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

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

Download MS SQL Server Interview Questions And Answers PDF

Previous QuestionNext Question
What Is a Schema in MS SQL Server 2005?How To List All Schemas in a Database?