Dependies of a copied table

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Raser
    New Member
    • Jul 2011
    • 1

    Dependies of a copied table

    I have copied a table from one database to another using
    create table tb_name select * from db_another.tb_n ame

    If a foriegn key was used in tb_name in db_another will the foriegn key reference to the similar table in the existing database or will it still point to the table in the db_another database
    If the dependencies are not sorted out How can I point it to the current database
    Thanks in advance.
  • ziycon
    Contributor
    • Sep 2008
    • 384

    #2
    It will look for the table that it was referencing the current database so if that table wasn't copied over it wont find it.

    Comment

    Working...