What is Schema in SQL Server & How to Create or Drop Schema - SQL Server / T-SQL Tutorial Part 27
SQL Server / TSQL Tutorial :
What is Schema in SQL Server & How to Create or Drop Schema
Link to the script used in the video
http://www.techbrothersit.com/2016/02...
What is Schema :
As per Microsoft website :
A Schema is distinct namespace to facilitate the separation, management, and ownership of database objects.
How to create Schema by GUI:
Open the SSMS and you will be going to Database as Schema are objects in the database. Go to Security and then Go to Schema and Right Click and Choose New Schema as shown below.
Now you need to provide the Schema name. I used TB as Schema Name and I left the Schema Owner empty, that means that dbo will be owner for this schema. If you would like to choose owner, you can hit search and provide the owner of schema.
Create Schema by using TSQL :
To create Schema in Database with default owner that is dbo, you can use below script.
--DatabaseName=TechBrothersIT
USE [TechBrothersIT]
GO
--Create Schema Name =TB
CREATE SCHEMA [TB]
GO
Let's say If I have a user in TechbrothersIT Database with name [aamir] and I would like to create Schema TB with owner name =[aamir]. I can use below script.
--Database Name = TechBrothersIT
USE [TechBrothersIT]
GO
--Create Schema TB with owner name =Aamir ( Database User)
CREATE SCHEMA [TB] AUTHORIZATION [aamir]
GO
How to Drop Schema from SQL Server Database:
We can also use TSQL Script to drop the Schema from a SQL Server Database. In below example, I am deleting TB Schema from TechBrothersIT Database.
--Database Name = TechBrothersIT
USE [TechBrothersIT]
go
--Drop Schema TB
Drop Schema [TB]
Check out our website for Different SQL Server, MSBI tutorials and interview questions
such as SQL Server Reporting Services(SSRS) Tutorial
SQL Server Integration Services(SSIS) Tutorial
SQL Server DBA Tutorial
SQL Server / TSQL Tutorial ( Beginner to Advance)
http://www.techbrothersit.com/
Watch video What is Schema in SQL Server & How to Create or Drop Schema - SQL Server / T-SQL Tutorial Part 27 online without registration, duration hours minute second in high quality. This video was added by user TechBrothersIT 19 April 2016, don't forget to share it with your friends and acquaintances, it has been viewed on our site 64,765 once and liked it 483 people.