Using this statement you can remove all data of rows or column ( complete data ) not table. In this there is no where clause but where clause is available in Delete statement. Truncate table is faster ...

Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file distributed with this work for additional information regarding copyright ...

-- Truncate the 'employee' table to remove all rows but keep the table structure. -- Truncating a table is faster than DELETE since it doesn't log individual row deletions. -- Note: Truncating a table ...

etc.). Commonly used DDL in SQL querying are CREATE, ALTER, DROP, and TRUNCATE. The mandatory semi-colon at the end of the statement is used to process every command before it. In this example, the ...