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

Q

How To Create a New Schema in a Database in SQL Server?

✍: FYIcenter.com

A

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.

 

Creating and Managing Schemas in SQL Server

⇒⇒SQL Server Database Tutorials

2016-10-22, 499👍, 0💬