SQL DROP TABLE - The Coding Shala
Home >> Learn Sql >> SQL DROP TablePlease leave a comment below if you like this post or found some error, it will help me to improve my content.
Other Posts You May Like
SQL DROP TABLE STATEMENT
SQL DROP TABLE Statement is used to delete a table from the database and all its data from the database.
SQL DROP TABLE Syntax
The following DROP TABLE statement is used to delete tables from the database -
DROP TABLE table_name;
SQL DROP TABLE Example
The following statement removes the 'Persons' Table from the database and all of its data from the database-
DROP TABLE Persons;
SQL TRUNCATE TABLE
- 'TRUNCATE' command is used to delete the data of a table, not the table itself.
SQL TRUNCATE TABLE Syntax
The following SQL statement is used to truncate table -
TRUNCATE TABLE table_name;
Prev<< SQL CREATE Table NEXT >>SQL INSERT Query
Post a Comment