Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: changing the name of a table

    Hi all I need to change the name of a table from Student_ind to Student_tbl. There are three tables that have a relationship with it, is there a nice and smooth way of changing it without upsetting the Relationships involved??

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    First of all, I think that this rename is a bad idea. If someone using your schema needs a suffix like "Student_tbl" to identify which objects are tables, then the suffix ought to be much more self-documenting and less obscure. Something like "Student <-- Note: this object is a table, it is not a view or a function. Be careful, don't confuse them" would be much clearer to the casual user and it would be so much harder to type that an experienced user would quickly fix the naming problems within the schema!

    After that "first of all", I'm not going to add a "second"... That's enough!

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    ok then I wont rename it at all I will leave it as is thank you

Posting Permissions

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