How transfer table from one schema to another schema in Sql server: SQL Server Interview Question

SQL Server Interview Question: Write down the query to transfer a table from Sales schema to Purchases schema?

Ans: ALTER SCHEMA Purchases TRANSFER Sales.Customer

Click here for more than 300 Sql server Interview questions

Kindly Visit our Job search tool