Alter Table name

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Disha
    New Member
    • Sep 2006
    • 1

    Alter Table name

    Hi All,
    i wanted to know how should i alter the name of a table.
    Im using Alter table name Rename to new_name.

    But its not working


    kindly help me out!!!!!
  • Senthil
    New Member
    • Sep 2006
    • 10

    #2
    Hi,

    Find the query for raname table name,

    sp_rename 'OLD_Name','NEW _Name'


    sp_rename :

    Changes the name of a user-created object (for example, table, column, or user-defined data type) in the current database.

    Syntax
    sp_rename [ @objname = ] 'object_name' ,
    [ @newname = ] 'new_name'
    [ , [ @objtype = ] 'object_type' ]

    Regards,
    Sharmila

    Comment

    • DotNetProgrammer2015
      New Member
      • Nov 2008
      • 1

      #3
      Thanks for the useful reply.

      Comment

      Working...