+ 1

What is truncate command

11th Dec 2016, 6:52 AM
Swapnamayee Panda
Swapnamayee Panda - avatar
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;
11th Dec 2016, 7:57 AM
Ahamad Irfan
Ahamad Irfan - avatar
+ 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
12th Dec 2016, 7:49 AM
Jacob Mathew
Jacob Mathew - avatar
+ 1
it is a commands to erase all the data in given table
11th Dec 2016, 10:59 AM
Dipesh Basnet
Dipesh  Basnet - avatar