how to change new schema name from existing schema - Table

• SQL Galaxy

  One Orange Chip

  Points: 29478

  More actions

  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

• Lowell

  SSC Guru

  Points: 323522

  More actions

  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!

• clin27

  Grasshopper

  Points: 11

  More actions

  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 4 years, 9 months ago by clin27.

• ScottPletcher

  SSC Guru

  Points: 101192

  More actions

  September 8, 2020 at 3:50 pm

  #3787031

  ALTER SCHEMA [dbo] TRANSFER HWData.DesktopSoft_Master;

  SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".