SQL is a non-procedural dialect. Client can compose SQL script to execute and SQL compiler consequently produces a method to get to database and convey the fancied output. SQL is a database coding, planned for the recuperation and organisation of data in social database. SQL Truncate command is utilized to erase all rows from the current table in the database."SQL Truncate Table" command shows how to truncate the rows in a table.

By viewing the below example, the concept of truncate command can be understood easily. [c]sql> select * from employee; +--------+--------+-----------+-------+------------+ | emp_id | ename | job | sal | commission | +--------+--------+-----------+-------+------------+ | 1001 | kate | manager | 14000 | 10 | | 1002 | jack | scaleman | 13000 | 20 | | 1003 | maddie | business | 14000 | 30 | | 1004 | madd | business | 14000 | NULL | | 1005 | winni | marketing | 14500 | NULL | +--------+--------+-----------+-------+------------+ 5 rows in set (0.00 sec) sql> truncate table employee; Query OK, 0 rows affected (0.37 sec) sql> select * from employee; +--------+--------+-----------+-------+------------+ | emp_id | ename | job | sal | commission | +--------+--------+-----------+-------+------------+ Empty set (0.37 sec) [/c] The above example, truncate command will delete all the existing data from the table employee.

• SQL Truncate Table - Truncate table is utilized to erase all the lines from the table.