Collections:
Transferring Tables from One Schema to Another in SQL Server
How To Transfer an Existing Table from One Schema to Another Schema in SQL Server?
✍: FYIcenter.com
If you want to move an existing table from one schema to another schema, you can use the "ALTER SCHEMA ... TRANSFER ..." statement as shown in the tutorial exercise below:
-- Login with "sa" USE FyiCenterData; GO -- Confirming that "fyi_links" is in "dbo" SELECT t.name AS table_name, t.type_desc, s.name AS schema_name FROM sys.tables t, sys.schemas s WHERE t.schema_id = s.schema_id AND t.name = 'fyi_links'; GO table_name type_desc schema_name ----------- ----------- ------------ fyi_links USER_TABLE dbo -- Moving a table to a new schema ALTER SCHEMA fyi TRANSFER fyi_links; GO -- Confirming that "fyi_links" is moved to "fyi" SELECT t.name AS table_name, t.type_desc, s.name AS schema_name FROM sys.tables t, sys.schemas s WHERE t.schema_id = s.schema_id AND t.name = 'fyi_links'; GO table_name type_desc schema_name ----------- ----------- ------------ fyi_links USER_TABLE fyi
The last query confirms that table "fyi_links" is now in schema "fyi".
⇒ "sys.objects" - Listing All Objects in a Given Schema in SQL Server
⇐ Creating a New Table in a Given Schema in SQL Server
2016-10-22, 1273🔥, 0💬
Popular Posts:
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...