use olddatabase_name
go
create database dbname
select * into dbname.student1 from student where 1=2
select * into dbname.teacher1 from teacher where 1=2
select * into dbname.admin1 from admin where 1=2
select * into dbname.exam11 from exam1 where 1=2
create database dbname
select * into dbname.student1 from student where 1=2
select * into dbname.teacher1 from teacher where 1=2
select * into dbname.admin1 from admin where 1=2
select * into dbname.exam11 from exam1 where 1=2