Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

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

Pravesh Singh 2553 06 May 2013

Hi All!
I have a table that got into the "db_owner" schema, and I need it in the "dbo" schema.
Is there a script or command to run to switch it over?
Thanks in advance!

1 Answers

AVADHESH PATEL 06 May 2013

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.

MindStick Training

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.