Difference between revisions of "Msql - Squirrel"
From Blue-IT.org Wiki
(Created page with "== Tables == === TRUNCATE === To delete all table data but preserve the table data do: TRUNCATE TABLE [datatbase].[prefix].[tablename]") |
(→TRUNCATE) |
||
| Line 3: | Line 3: | ||
To delete all table data but preserve the table data do: | To delete all table data but preserve the table data do: | ||
| − | TRUNCATE TABLE [ | + | TRUNCATE TABLE [database].[prefix].[tablename] |
Latest revision as of 11:00, 8 May 2014
Tables
TRUNCATE
To delete all table data but preserve the table data do:
TRUNCATE TABLE [database].[prefix].[tablename]