SQL DROP TABLE and TRUNCATE TABLE Keywords

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP







<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]
-->



SQL DROP TABLE and TRUNCATE TABLE Keywords


❮ SQL Keywords Reference



DROP TABLE


The DROP TABLE command deletes a table in
the database.



The following SQL deletes the table "Shippers":



Example



DROP TABLE Shippers;

Try it Yourself »



Note: Be careful before deleting a table. Deleting a
table results in loss of all information stored in the table!




TRUNCATE TABLE


The TRUNCATE TABLE command deletes the data inside a table, but
not the table itself.


The following SQL truncates the table "Categories": 



Example



TRUNCATE TABLE Categories;

Try it Yourself »



❮ SQL Keywords Reference


Popular posts from this blog

Malaysia to Papua New Guinea by motorcycle?

List of Bhojpuri films

.name