2 Easy SQL Queries to Drop and Modify Table

Here are two SQL queries to drop or modify a table.

IN THIS PAGE

1. Don’t Miss
2. SQL query to drop a table
3. SQL query to modify a table
4. SQL query to rename and truncate

SQL query to drop a table

The widely used SQL query to drop a table syntax is as below.

DROP TABLE [<Schema>.] <Table_Name> [CASCADE CONSTRAINTS];

Explanation

• In place of TABLE_NAME, use your table name
• In place of schema, use your schema
• The Cascade constraints drop all referential integrity constraints that refer to primary and unique keys in the dropped table

Example

I am here deleting the HR_OPER table from the database. I used CASCADE constraints, which deletes all the constraints.

DROP TABLE HR_OPER CASCADE CONSTRAINTS;

SQL query to modify a table

The statement ALTER TABLE you can use to modify a table. Below are the possible ALTER TABLE operations you can apply to a Table.

Basically, the alter table modifies a table.

Example

ALTER TABLE Student ADD StudHall# CHAR (4) ADD FOREIGN KEY (StudHall#) REFERENCES Hall (Hall#);

SQL query to rename and truncate

As part of modifying a table, you can rename an existing table. In addition to that, you can truncate all the records in a table. We will see with syntax how you can do those.

The syntax for renaming and truncating

Example

RENAME HR1 TO HR2;
TRUNCATE TABLE HR_OPER;

Related posts