Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Tuesday, 11 April 2017

SQL Table Truncate


It is used to remove all the rows from table and save permanently in database
It will not support where clause

  Truncate = Delete + Commit;

Syntax:
Truncate table <Table_Name>;

Example:

TRUNCATE TABLE Emp;

TRUNCATE TABLE Student;
Share this article :

1 comments:

  1. Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check oracleappstechnical.com

    ReplyDelete