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 questionsAns: ALTER SCHEMA Purchases TRANSFER Sales.Customer