The TRUNCATE command deletes all records from a table.
TRUNCATE is similar to DELETE but executes much faster and more efficient.
TRUNCATE cannot be used when a foreign key constraint prevents deletion.
Delete all Supplier records.
TRUNCATE TABLE Supplier
This type of operation may not complete, because of referential integrity constraints.
TRUNCATE TABLE table-name