Sample Dept Table with Data

CREATE TABLE DEPT

(

DeptID INT

,Name VARCHAR(30)

,Location VARCHAR(30)

);

Sample data insertion Script:

INSERT INTO DEPT VALUES

(10,'Design','Hyd'),

(20,'Sales','Bang'),

(30,'Accounts','Che'),

(40,'Maintenance','Pune'),

(50,'Engineering','Delhi');

See Also: Sample Employee Table creation with data