student.sql

来自「jtable 数据库的一个小例子」· SQL 代码 · 共 46 行

--建立 Student 数据库,如果存在,先将其删除
use master

if exists(select * from sysdatabases where name='Student')
drop database Student
go

create database Student  --创建数据文件
on primary
(
	name='Student_data',
	filename='F:\JBuilder\JTableTest\Student\Student_data.mdf',
	size=5mb,
	maxsize=100mb,
	filegrowth=15%
)
log on		      --创建日志文件
(
	name='Student_log',
	filename='F:\JBuilder\JTableTest\Student\Student_log.ldf',
	size=2mb,
	filegrowth=1
)
go

use Student

if exists (select * from sysobjects where name='Student')
drop table Student

create table Student
(
	id int primary key identity(1,1),
	name varchar(20) not null,
	age int not null,
	address varchar(20) not null,
)
go

insert into Student values('到你身边',19,'洛王开发区')
insert into Student values('梦亦有忧',21,'岳阳')
insert into Student values('张三',45,'新路口')
insert into Student values('李四',64,'五里牌')
insert into Student values('王五',9,'汽车站')

select * from student