Learn Sql server in hindi/urdu part-2 (Constraints ,not null ,unique, id...

create database sql1707b1



use sql1707b1







create table student

(



id int primary key identity,

name nvarchar(20) not null,

batchcode nvarchar(20) not null,

contactnumber nvarchar(20) not null unique



)









insert into student (name,batchcode,contactnumber)

values('safeer','1707b1','03425321680')





insert into student (name,batchcode,contactnumber)

values('naseer','1707b1','03415321680')







delete from student --deleting record..........

drop table student





select * from student





select * from student where id=1