OneCompiler

Anyone , what is the meaning of TRUNCATE here ! (EASY)...

use abc;

create table employee
(EMP_ID char(4) primary key,
NAME char(10) unique,
dept_id char(2),
location char(100) not null
);

Insert into employee values
('E001','abcd','D1','xyz India');

Insert into employee values
('E002','abcde','D2','bed USA');

Insert into employee values
('E002','DAVID','D3','abc England');

truncate table employee;

1 Answer

2 years ago by

@SARTHAK that means, remove all rows from the table employee

2 years ago by Karthik Divi