Database - Database Redesign - Discussion
Discussion Forum : Database Redesign - General Questions (Q.No. 4)
4.
Which SQL-92 standard SQL command can be used to change a table name?
Discussion:
7 comments Page 1 of 1.
Shiv mohan agarwal said:
1 year ago
Agree, option A is the correct answer.
Shoaib Khan said:
3 years ago
Alter TABLE STUDENTS RENAME TO ARTIST.
Yes, we can rename table using above query.
Yes, we can rename table using above query.
Ganny said:
9 years ago
It renames the old table name to new table name.
Sudha said:
9 years ago
The rename command is used to rename a table.
Following is its Syntax,
rename table old-table-name to new-table-name. But why the answer D?
Following is its Syntax,
rename table old-table-name to new-table-name. But why the answer D?
Simran said:
1 decade ago
ALTER TABLE table_name
RENAME TO new_table_name;
RENAME TO new_table_name;
Aman said:
1 decade ago
Syntax to change the table name
alter table
table_name
rename to
new_table_name;
alter table
table_name
rename to
new_table_name;
Amar said:
1 decade ago
If it is not the command to change the table name then what is the command, plese answer !
(1)
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers