实验二创建实验用的数据库.docVIP

嘉应学院计算机学院 一、实验目的 通过实验掌握使用SQL SERVER向导和标准的SQL语言在SQL SERVER数据库管理系统中建立数据库和SQL的定义基本表、修改基本表和删除基本表的方法。 二、实验原理 数据库的数据定义： Syntax 1、CREATE DATABASE database_name [ ON [ filespec [ ,...n ] ] [ , filegroup [ ,...n ] ] ] [ LOG ON { filespec [ ,...n ] } ] [ COLLATE collation_name ] [ FOR LOAD | FOR ATTACH ] filespec ::= [ PRIMARY ] ( [ NAME = logical_file_name , ] FILENAME = os_file_name [ , SIZE = size ] [ , MAXSIZE = { max_size | UNLIMITED } ] [ , FILEGROWTH = growth_increment ] ) [ ,...n ] filegroup ::= FILEGROUP filegroup_name filespec [ ,...n ] File type File name extension Primary data file .mdf Secondary data file .ndf Transaction log file .ldf 2、CREATE TABLE CREATE TABLE [ database_name.[ owner ] . | owner. ] table_name ( { column_definition | column_name AS computed_column_expression | table_constraint ::= [ CONSTRAINT constraint_name ] } | [ { PRIMARY KEY | UNIQUE } [ ,...n ] ) [ ON { filegroup | DEFAULT } ] [ TEXTIMAGE_ON { filegroup | DEFAULT } ] column_definition ::= { column_name data_type } [ COLLATE collation_name ] [ [ DEFAULT constant_expression ] | [ IDENTITY [ ( seed , increment ) [ NOT FOR REPLICATION ] ] ] ] [ ROWGUIDCOL] [ column_constraint ] [ ...n ] column_constraint ::= [ CONSTRAINT constraint_name ] { [ NULL | NOT NULL ] | [ { PRIMARY KEY | UNIQUE } [ CLUSTERED | NONCLUSTERED ] [ WITH FILLFACTOR = fillfactor ] [ON {filegroup | DEFAULT} ] ] ] | [ [ FOREIGN KEY ] REFERENCES ref_table [ ( ref_column ) ] [ ON DELETE { CASCADE | NO ACTION } ] [ ON UPDATE { CASCADE | NO ACTION } ] [ NOT FOR REPLICATION ] ] | CHECK [ NOT FOR REPLICATION ] ( logical_expression ) } table_co