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

 

sys.schemas - Listing All Schemas in a Database in SQL Server

What Is a Schema in SQL Server 2005 in SQL Server

Creating and Managing Schemas in SQL Server

⇑⇑ SQL Server Database Tutorials

2016-10-22, 1212🔥, 0💬