if exists (select * from sysdatabases where name='myClass')
drop database myClass
go
create database myClass
on primary
(
name='myClass_data',
filename='d:/myClass_data_db.mdf',
size=100mb,
filegrowth=10%
)log on
(
name='myClass_log',
filename='d:/myClass_log.ldf',
size=10mb,
filegrowth=10mb
)
go
create table student
(
stuID identity(100,1) primary key ,
stuName varchar(50) not null,
stuNo char(6) not null,
stuAge int not null,
stuSeat smallint not null,
stuAddress text
)
go