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