In sql server 2005, how do I change the “schema” of a table without losing any data?

Question

AVADHESH PATEL · Answer

Hi Pravesh!In SQL Server Management Studio:Right click the table and select modify (it's called "Design" now)On the properties panel choose the correct owning schema.

forum

In sql server 2005, how do I change the “schema” of a table without losing any data?

Can you answer this question?

1 Answers