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

Comments

Archive

Contact Form

Send