Collections:
"DROP SCHEMA" - Dropping an Existing Schema in SQL Server
How To Drop an Existing Schema in SQL Server?
✍: FYIcenter.com
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.
⇒ Managing Security, Login and User in SQL Server
⇐ Accessing a Schema Not Owned by You in SQL Server
2016-10-20, 1389🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...