Alter Schema in SQL Server, how to move a table, such as ABC_table, from its current scheme (scheme1) to another scheme (scheme2)

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

ALTER SCHEMA schema2 TRANSFER schema1.ABC_table;

ALTER SCHEMA can only be used to move securables between schemas in the same database.

To change or drop a securable within a schema, use the ALTER or DROP statement specific to

that securable.

You can access www.free-online-exams.com for the whole latest version of the exam

Get Oracle Certifications for all Exams
Free Online Exams.com