if object_id('student', 'U') is not null

	drop table student

go

create table student(

	sno		varchar(20) not null ,

	sage	decimal not null,

	sname	varchar(20)

)

go

create nonclustered index stu_index on student(sno)

go

if(object_id('person', 'U') is not null)

	drop table person

go

create table person(

	sname varchar(20) not null

)

go

alter table person add primary key(sname)

go

create nonclustered index person_index on person(sname)

go

alter table student add primary key(sno, sage)

go

alter table student add foreign key(sname) references person(sname)

go