JR Kincaid
Reputation: 823
Create Schema in SSMS
I know it is ridiculously easy to create a schema in TSQL:
CREATE SCHEMA <Schema Name>
I had someone ask how to do this through SQL Server Management Studio. I couldn't locate the context menu item to replicate this in SSMS. Anyone know how?
Upvotes: 8
Views: 12338
Answers (1)
rciq
Reputation: 1309
In Object Explorer go to: Databases -> [YourDatabase] -> Security -> Schemas -> (right-click) New schema
Upvotes: 26
Related Questions
- How to create a SQL Schema in a Query?
- How do I create a SQL table under a different schema?
- How do I change db schema to dbo
- MS SQL Server Management Studio - How to create new schema
- How to add a new schema to sql server 2008?
- Script out schema in SQL Server
- How to create table in SYS schema in SQL Server?
- Create Schema in SSMS
- schema in sql server 2008
- How do I create a schema like .dbo in SQL Server [2005]