Answers

Question and Answer:

  Home  MS SQL Server

⟩ 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 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.

 148 views

More Questions for you: