"DROP SCHEMA" - Dropping an Existing Schema in SQL Server

Q

How To Drop an Existing Schema in SQL Server?

✍: FYIcenter.com

A

If you want to delete a schema, you need to move all objects out of that schema, then use the "DROP SCHEMA" statement to delete the schema. The tutorial exercise below shows you how to drop schema "fyi":

-- Login with "sa"

USE FyiCenterData;
GO

-- Drop failed because schema is not empty
DROP SCHEMA fyi;
GO
Msg 3729, Level 16, State 1, Line 1
Cannot drop schema 'fyi' because it is being referenced 
   by object 'DF__fyi_links__creat__4316F928'.

-- Move one table out
ALTER SCHEMA dbo TRANSFER fyi.fyi_links;
GO

-- Delete one table
DROP TABLE fyi.test;
GO

-- Dropped ok
DROP SCHEMA fyi;
GO
Command(s) completed successfully.

 

Creating and Managing Schemas in SQL Server

⇒⇒SQL Server Database Tutorials

2016-10-20, 460👍, 0💬