As an SQL developer, I was required to create a new schema for the SQL server. I have identified a few simple approaches to this. In this article, I will walk you through each approach individually.
Approach 1: Using the CREATE SCHEMA Statement
This is the basic approach to do this task.
Syntax
CREATE SCHEMA SchemaName;
Example
We can execute the below SQL query to create the schema named USA.
CREATE SCHEMA USA;
After executing the above query, I got the expected output, as shown in the screenshot below.

We can execute the below select query to check if the schema was created successfully.
Select * from sys.schemas;

Check out How To Change Schema Of A Table In SQL Server
Approach 2: Creating Schema with Owner
We can also create the schema with the owner’s name.
Syntax
CREATE SCHEMA SchemaName AUTHORIZATION OwnerName;
Example
We can execute the query below to create a USA schema with the USALead owner.
CREATE SCHEMA USA AUTHORIZATION USALead;
Check out How To Create A Table With Identity Column In SQL Server
Approach 3: Using SQL Server Management Studio (SSMS)
Follow the below steps.
1. Expand the Database name in SSMS.
2. Right-click on the Security folder

3. Enter the Schema name and then click on the Ok button, as shown in the screenshot below.

Now, you can see below that the schema was created successfully.

Conclusion
Creating a schema in an SQL server database is easy using multiple approaches, as mentioned in this article.
You may also like following the articles below.
- How To Check Table Description In SQL Server
- How To Check If CDC Is Enabled On A Table In SQL Server
- How To Find Table With Column Name in SQL Server

Grey is a highly experienced and certified database expert with over 15 years of hands-on experience in designing, implementing, and managing complex database systems. Currently employed at WEX, USA, Grey has established a reputation as a go-to resource for all things related to database management, particularly in Microsoft SQL Server and Oracle environments. He is a Certified Microsoft SQL Server Professional (MCSE: Data Management and Analytics) and Oracle Certified Professional (OCP), with Extensive database performance tuning and optimization knowledge and a proven track record in designing and implementing high-availability database solutions.