潇雨----航班订票系统

if exists (select * from sysdatabases where name='Flight') drop database Flight go create database Flight on primary ( name=Flight_data, filename='E:\我的项目\航班订票系统\DataBase\Flight_data.mdf', size=3mb, maxsize=4mb, filegrowth=1mb ) log on ( name=Flight_log, filename='E:\我的项目\航班订票系统\DataBase\Flight_log.ldf', size=2mb, maxsize=3mb, filegrowth=1mb ) Collate Chinese_PRC_CI_AS go use Flight go create table FlightSystem ( flightID smallint identity (1,1) not null, flightCompany varchar(30) not null, flightSeat varchar(20) not null, StartTime varchar(20) not null, EndTime varchar(20) not null, Departure varchar(20) not null, Arrival varchar(20) not null ) go select * from FlightSystem go alter table FlightSystem add constraint PK_flightID primary key (FlightID) go alter table FlightSystem drop constraint Pk_flightID go alter table FlightSystem add constraint PK_flightCompany primary key (flightCompany) go