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, 1393🔥, 0💬
Popular Posts:
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...