Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    101

    Unanswered: question on renaming columns

    Hi,
    Quick question!
    Is there anyway to rename a column such that it reflects all columns on all reference tables, stored procedures,views, etc.,
    Ex. table1 is with col1 (primary key)

    table2 with col2, col1(FK--table1(col1)

    if i try to rename col1 on table1 it has to rename col1 on table2 automatically.
    Any help is greatly appreciated.
    -SS

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    First, buy a magic wand.....

    I've left typos alone because it wasn't worth the risk....or energy...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •