Help with removing a schema ID please ?

• mw_sql_developer

  SSCoach

  Points: 19443

  More actions

  December 18, 2015 at 7:18 am

  #303308

  I have a table that I copied from another database that has the name

  MDCH.Hist5657

  I need to get rid of that MDCH schema and the table must reside in the dbo schema.

  Any help how to do that

  Anyway other than

  Select * INTO Hist5657 from MDCH.Hist5657

• Ant-Green

  SSC Guru

  Points: 112965

  More actions

  December 18, 2015 at 7:23 am

  #1846765

  ALTER SCHEMA dbo TRANSFER MDCH.Hist5657;

  GO

• johnwalker10

  SSCrazy Eights

  Points: 9124

  More actions

  December 18, 2015 at 10:02 pm

  #1846909

  DROP SCHEMA [ IF EXISTS ] schema_name