21 September 2014

Tip: How to change the schema of tables in SQL


ALTER SCHEMA dbo TRANSFER dbuser.table1

This will transfer the ownership of table1 from dbuser schema to dbo.

No comments:

Post a Comment