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
@SARTHAK that means, remove all rows from the table employee
2 years ago by Karthik Divi