In SQL, the
TRUNCATE
statement removes all the data from a table. The TRUNCATE
statement is not actually a part of the SQL standard, but many relational database management systems implement it. It is equivalent in function to a DELETE FROM my table;
statement. However, on some systems, it is implemented differently.The syntax for issuing a truncate command on a table could be implemented as: Truncate Table [schema][.] <table_name>;
No comments:
Post a Comment