Menu
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?
892
In SQL Server, a schema is a logical collection of database objects such as tables, views, stored procedures, indexes, triggers, functions. It can be thought of as a container, created by a database user. The database user who creates a schema is the schema owner.
A SQL schema is a useful database concept. It helps us to create a logical grouping of objects such as tables, stored procedures, and functions.
CREATE SCHEMA can create a schema, the tables and views it contains, and GRANT, REVOKE, or DENY permissions on any securable in a single statement. This statement must be executed as a separate batch. Objects created by the CREATE SCHEMA statement are created inside the schema that is being created.
In Object Explorer go to: Databases -> [YourDatabase] -> Security -> Schemas -> (right-click) New schema
97
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
