+ 1
What is truncate command
3 Réponses
+ 3
It is used as Truncate Table command..
it is a DDL command.
The TRUNCATE TABLE statement is used to remove all records from a table in SQL Server. It performs the same function as a DELETE statement without a WHERE clause.
The basic syntax of TRUNCATE TABLE is as follows:
TRUNCATE TABLE table_name;
+ 2
the truncate command allows u to truncate that is cut off a part of a number
Ex : TRUNCATE (123.124,1); will give an output 12.1
+ 1
it is a commands to erase all the data in given table