Untitled

use master

create table customer(
	cust_no numeric(4) primary key,
	lname varchar(10),
	fname varchar(15),
	addr varchar(20),
	city varchar(15),
	states varchar(20),
	pin numeric(5),
	bithdate date

);

select * from customer
insert into customer
values (98, 'Mayaa', 'Prasad', 'mutu', 'nasa', 'ragat', 12345, '22-jun-03');

select * from customer