How to rename a table in sql?

Question

I try to rename the table 'folks' to 'users'. How does it work?

Poor try to get some rep with a simple question that has been asked back in the stoneage already. You have a gold badge and > 1k rep. You are experienced enough to know that this kind of duplicate question asking + self-answering is not how Stackoverflow works. — Daniel W., Dec 12 '16 at 09:07
@DanFromGermanylol, first of first, i was searching if the question exists, but nothing came up. Second it is even desired from SO to answer own questions Q&A style. Go ahead and create a new question and look what the text on the bottom says. "Answer your own question – share your knowledge, Q&A-style" — Black, Dec 12 '16 at 09:31

score 1 · Answer 1 · edited Sep 25 '17 at 15:17

1

In this case you can use ALTER TABLE with RENAME TO.

Syntax:

ALTER TABLE <Tablename>
RENAME TO <new Tablename>;

Example:

ALTER TABLE folks
RENAME TO users;

edited Sep 25 '17 at 15:17

Graham

answered Dec 11 '16 at 13:53

Black

score 0 · Answer 2 · answered Dec 11 '16 at 14:00

0

If you want to rename the column and also change its type

ALTER TABLE [TableName] CHANGE [Column] [ColumnName] [New type];

For example:

ALTER TABLE folks CHANGE FolkAddress Address VARCHAR(1024);

answered Dec 11 '16 at 14:00

james_bond

But in which step are you renaming it to `users`? – Black Dec 11 '16 at 14:30
1

I'm not, your problem description does not match the question name. – james_bond Dec 11 '16 at 15:12

2 Answers2