1、实验 1 数据库定义实验目的1、掌握 SQL 数据定义功能：数据库定义、表的定义、索引定义。实验内容1、创建 spj 数据库(1) 供应商表 S列名 说明 数据类型 约束SNO 供应商号 CHAR(6) PRIMARY KEYSNAME 供应商名 VARCHAR(20) NOT NULLSTATUS 供应商状态 VARCHAR(50)CITY 所在城市 VARCHAR(50)(2) 零件表 P列名 说明 数据类型 约束PNO 零件号 CHAR(6) PRIMARY KEYPNAME 零件名 VARCHAR(20) NOT NULLCOLOR 颜色 CHAR(2)WEIGHT 重量 NUMERI
2、C(9,2) CHECK(WEIGHT0 AND WEIGHT | | | ,.n ) ON partition_scheme_name ( partition_column_name ) | filegroup | “default“ TEXTIMAGE_ON filegroup | “default“ FILESTREAM_ON partition_scheme_name | filegroup | “default“ WITH ( ,.n ) ; ALTER TABLE database_name . schema_name . | schema_name . table_name AL
3、TER COLUMN column_name type_schema_name. type_name ( precision , scale | max | xml_schema_collection ) COLLATE collation_name NULL | NOT NULL SPARSE | ADD | DROP ROWGUIDCOL | PERSISTED | NOT FOR REPLICATION | SPARSE | WITH CHECK | NOCHECK | ADD | | | ,.n | DROP CONSTRAINT constraint_name WITH ( ,.n
4、) ,.n | COLUMN column_name ,.n ,.n | WITH CHECK | NOCHECK CHECK | NOCHECK CONSTRAINT ALL | constraint_name ,.n | ENABLE | DISABLE TRIGGER ALL | trigger_name ,.n | ENABLE | DISABLE CHANGE_TRACKING WITH ( TRACK_COLUMNS_UPDATED = ON | OFF ) | SWITCH PARTITION source_partition_number_expression TO targe
5、t_table PARTITION target_partition_number_expression | SET ( FILESTREAM_ON = partition_scheme_name | filegroup | “default“ | “NULL“ )| REBUILD PARTITION = ALL WITH ( ,.n ) | PARTITION = partition_number WITH ( ,.n ) | | ; CREATE UNIQUE CLUSTERED | NONCLUSTERED INDEX index_name ON ( column ASC | DESC ,.n ) INCLUDE ( column_name ,.n ) WHERE WITH ( ,.n ) ON partition_scheme_name ( column_name ) | filegroup_name | default FILESTREAM_ON filestream_filegroup_name | partition_scheme_name | “NULL“ ;
