Home >> FAQs/Tutorials >> SQL Server FAQ

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

By: FYIcenter.com

(Continued from previous topic...)

How To Drop an Existing Schema?

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.

  1. What Is a Schema in SQL Server 2005?
  2. How To Create a New Schema in a Database?
  3. How To List All Schemas in a Database?
  4. How To Create a New Table in a Given Schema?
  5. How To Transfer an Existing Table from One Schema to Another Schema?
  6. How To List All Objects in a Given Schema?
  7. What Is the Default Schema of Your Login Session?
  8. Who Is the Owner of a Schema?
  9. How To Change the Ownership of a Schema?
  10. What Happens If You Are Trying to Access a Schema Not Owned by You?
  11. How To Drop an Existing Schema?

Related Articles:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...