none
How do I change the table owner? RRS feed

  • Question

  • I have to make a copy of an existing database and call it something different. That part was easy because I simply backed it up and then restored it with a different name.

    OrigDbName

    Table1 Owner OrigDdName

    Table2 Owner OrigDdName

    But now I find that all the tables still have the original database name as the owner and I cannot refer to them programmatically unless I use the original database name.

    NewDbName

    Table1 Owner OrigDdName

    Table2 Owner OrigDdName

    So how do I change the owner of the tables to the new database name. What I really need is;

    NewDbName

    Table1 Owner NewDdName

    Table2 Owner NewDdName

    Please be as specific as possible because I am not a DBA and I am out of my depth once it gets beyond the basics of using commands like Alter Table.

    Thank you.

    Thursday, November 16, 2006 11:12 PM

Answers

All replies