SQL 数据库设计.docVIP

1) 创建一个数据库名为“MOVIE”在此数据库中创建此3个表； 2) 用SQL语言填实例表： ____________________________________________________ USE MASTER GO if exists (select * from dbo.sysdatabases where name =’MOVIE’) drop database MOVIE GO CREATE DATABASE MOVIE ON (NAME= MOVIE _Data, FILENAME=e:\data\ MOVIE.mdf, SIZE=5MB, MAXSIZE=20MB, FILEGROWTH=10%) LOG ON (NAME= MOVIE _Log, FILENAME=e:\data\ MOVIE.ldf, SIZE=2MB, MAXSIZE=5MB, FILEGROWTH=1MB) GO USE MOVIE IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = TICKET) DROP TABLE TICKET GO