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.
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 Question | Next Question |
What Is a Schema in MS SQL Server 2005? | How To List All Schemas in a Database? |