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, 1405🔥, 0💬
Popular Posts:
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...