Recent

Show all results for ""

Ace your exams with our all-in-one platform for creating and sharing quizzes and tests.

Quizzes

Create quizzes and tests automatically from your content using AI.

Flashcards

Automatically turn your notes into digital flashcards.

Share, Export & Embed

Share with classmates or export to Excel and your learning management system.

Stats & Reporting

Auto-grading quizzes and tests with detailed stats and reports.

Mobile Apps

The smarter way to study – wherever you are.

Pricing

Resources

Search...

By @rubaitulazad

SQL Table and Column Modification Quiz

Created by EloquentEnlightenment7533

Download PDF Download

Start Quiz

Study Flashcards

6 Questions

What SQL statement is used to rename a table in a database?

RENAME TABLE TABLENAME (OLD) TO ….(NEW);

Which SQL statement is used to add a new column to an existing table?

ALTER TABLE table_name ADD column_name datatype;

What SQL statement is used to change the name of a column in a table?

ALTER TABLE table_name RENAME COLUMN old_name to new_name;

What SQL statement is used to modify the data type of a column in a table?

ALTER TABLE table_name MODIFY COLUMN column_name datatype;

Which SQL statement is used to add a new column to an existing table?

ALTER TABLE - ADD Column

What SQL statement is used to rename a table in a database?

RENAME TABLE TABLENAME (OLD) TO ….(NEW);

Study Notes

SQL Table Modifications

The ALTER TABLE statement is used to rename a table in a database.
The ALTER TABLE statement is used to add a new column to an existing table.
The ALTER TABLE statement with the RENAME COLUMN clause is used to change the name of a column in a table.
The ALTER TABLE statement with the MODIFY clause is used to modify the data type of a column in a table.
Note that the ALTER TABLE statement serves multiple purposes, including renaming tables, adding new columns, renaming columns, and modifying column data types.

Test your SQL knowledge with this quiz on renaming, adding, and modifying tables and columns. Put your skills to the test with questions on RENAME TABLE, ALTER TABLE - ADD Column, ALTER TABLE - RENAME COLUMN, and ALTER TABLE - ALTER/MODIFY DATATYPE statements.