The SQL TRUNCATE TABLE clause deletes all rows from a database table. Here is the SQL TRUNCATE TABLE syntax:
TRUNCATE TABLE Weather
The SQL TRUNCATE TABLE clause does the same as a SQL DELETE clause which doesn't have a SQL WHERE clause. The following two SQL statements are equivalent:
TRUNCATE TABLE Weather
DELETE FROM Weather
Use SQL TRUNCATE TABLE only when you want to delete all rows in a table.
Best 60 – 65 inch Smart LED TV to Buy in India
Best 55 inch LED TV to Buy in India
TRUNCATE TABLE Weather
The SQL TRUNCATE TABLE clause does the same as a SQL DELETE clause which doesn't have a SQL WHERE clause. The following two SQL statements are equivalent:
TRUNCATE TABLE Weather
DELETE FROM Weather
Use SQL TRUNCATE TABLE only when you want to delete all rows in a table.
Best 60 – 65 inch Smart LED TV to Buy in India
Best 55 inch LED TV to Buy in India
0 comments:
Post a Comment