SQL Server使用教程课后的实验数据库yggl.docVIP

--实验2 创建数据库和表 use master go if exists(select * from sys.databases where name=yggl) drop database yggl go create database yggl on primary ( name=yggl_data, filename=D:\17李利巧\yggl_data.mdf, size=10mb, maxsize=50mb, filegrowth=5% ) log on ( name=yggl_log, filename=D:\17李利巧\yggl_log.ldf, size=2mb, maxsize=5mb, filegrowth=1mb ) go --drop database yggl use yggl go if exists(select * from sys.objects where name=Employees) drop table Employees go create table Employees ( EmployeeID char(6) not null primary key, Name char(10) not null, Education char(4) not null, Birthday date not null,