In sql server 2005, how do I change the “schema” of a table without losing any data? February 15, 2023 by Tarik 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.