Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Tokyo, Japan
    Posts
    17

    Question Unanswered: Rename Table name

    Hi
    I don't want to change datas in a table which I use, but want to change only the table's name with T_SQL statments.

    As you know there are SPs for rename SP or view, but I can not find such SP for table.

    If you know about it,
    or have the another good method to rename table,
    tell me please.

    Thanks for reading.
    Takanobu Maekawa

  2. #2
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    sp_rename should work

    eg
    EXEC sp_rename 'customers', 'custs' (taken out of sp_rename in BOL)
    Regards
    Dbabren

  3. #3
    Join Date
    Jan 2004
    Location
    Tokyo, Japan
    Posts
    17

    Wink

    Now I do it as you said, then I can!
    thanks.
    Takanobu Maekawa

Posting Permissions

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