Post reply

how to change new schema name from existing schema - Table

  • August 18, 2011 at 5:25 am

    #242314

    Hi,

    I want change schema name on Table.

    hwdata.DesktopSoft_Master

    to change

    dbo.DesktopSoft_Master

    I tried as below

    ALTER SCHEMA HWData TRANSFER dbo.DesktopSoft_Master;

    Error-

    Msg 15530, Level 16, State 1, Line 1

    The object with name "DesktopSoft_Master" already exists.

    Can you give me script for change new schema Object.

    Thanks

  • August 18, 2011 at 7:19 am

    #1370101

    that error says the table already exists in the hwdata schema.

    do a quick

    select * from hwdata.DesktopSoft_Master

    select * from dbo.DesktopSoft_Master

    decide which one to keep (say dbo was the "good one"

    then drop table hwdata.DesktopSoft_Master

    and try to transfer again.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • August 18, 2011 at 7:23 am

    This was removed by the editor as SPAM

  • September 8, 2020 at 2:57 pm

    #3787017

    There are no such object in the destination schema, must be something else.

    • This reply was modified 3 years, 7 months ago by  clin27.

  • September 8, 2020 at 3:50 pm

    #3787031

    ALTER SCHEMA [dbo] TRANSFER HWData.DesktopSoft_Master;

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply