Home > DeveloperSection > Forums > In sql server 2005, how do I change the “schema” of a table without losing any data?
 Ask Question

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

Total Post:412

Points:2888

 1750  View(s)
Ratings:
Rate this:
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. Re: In sql server 2005, how do I change the “schema” of a table without losing any data?

    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.

Answer

Please check, If you want to make this post sponsored

You are not a Sponsored Member. Click Here to Subscribe the Membership.

© Copyright © 2010 - 2019 MindStick Software Pvt. Ltd. All Rights Reserved

DO YOU WISH TO IMPROVE YOUR BUSINESS ?

Once you’ve signed up as a user for a sponsorship on MindStick network, you will receive sponsored posting opportunities to apply for. It’s a great way to promote your product as a brand.

Yes, help me to improve my business No thanks x