Rename SQL database table

1142270 pts.
Tags:
SQL
SQL Database
For my SQL database, I have to rename one of my columns. What's the process to do that? Will a specific query work for this? I just have to change the name.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Check out Microsoft’s link. You may need to change it for your version ofo SQL server

LINK

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • CharlieBrowne
    Use the SQL ALTER TABLE Command.
    62,385 pointsBadges:
    report
  • edwinjhoffer
    ALTER TABLE tablename RENAME COLUMN oldcolumnname TO newcolumnname;
    3,740 pointsBadges:
    report
  • ToddN2000
    You can also do it using SQL server management studio. Open database, tables, find you table and expand the columns, right-click column and select rename.
    132,520 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: