Post reply

Altering Schema Of A Table

  • May 12, 2009 at 12:58 am

    #137720

    Hi everyone first thanks for help

    i have 2 different schemas on my database.

    such as schema1 and schema2

    we get datas from other servers using by SSIS.

    My problem is this.

    the new table should be schema1.importedtable

    but with a mistake i imported it as schema2.importedtable

    they gave us access to the source only one time. we approved that we got data and they deleted my rights for source . :crying:

    i tried to select into and insert into queries,but -actually i dont know why- the query takes more than 2 hours . and finally occurs time out etc. But theres only about 500000 records.

    i searched for altering schema but it changes all the schema. i need change only one table's schema

    Can anyone give any advice.

    Thanks for help .

  • May 12, 2009 at 1:16 am

    #992662

    Use this

    alter schema schema1 transfer schema2.table_name

  • May 12, 2009 at 1:57 am

    #992676

    Ratheesh.K.Nair (5/12/2009)

    Use this

    alter schema schema1 transfer schema2.table_name

    this worked.

    thanks a lot 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

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