数据库系统与应用实验和课程设计指导SQL2008.docVIP

select * from sys.servers where server_id=0 select * from sys.databases select * from sys.filegroups select * from sys.master_files select * from sys.database_files select * from sys.data_spaces create table test ( id int not null, name char(100) null, constraint pk_test primary key clustered ( id asc) ) create nonclustered index ix_test on test(name) select * from sys.objects where type_desc=user_table and name=test select * from sys.objects where type_desc=user_table and name=testor parent_object_id in ( select object_id from sys.objects where type_desc=user_table and name=test) select * from sys.columns where object_id =12 select * from sys.indexes where object_idselect * from sys.partitions where object_idselect * from sys.allocation_units select * from sys.allocation_units u,sys.partitions p where u.type in (1,3) and u.container_id=p.hobt_id and p.object_id=33 union all select * from sys.allocation_units u,sys.partitions p where u.type = 2 and u.container_id=p.partition_id and p.object_id=33 select * from sys.dm_db_partition_stats where object_id=33 select * from sys.index_columns where object_id=11 select * from sys.database_principals select * from sys.types --数据库的创建 create database educ on primary ( name= student_data, filename =C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\student_data.mdf, size=10MB, maxsize=50MB, filegrowth=1MB ) log on ( name =student_log, filename=C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\student_log.ldf, size=2MB, maxsize=5MB, filegrowth =1% ) --创建测试数据 use educ go create table student(s varchar(10),sname nvarchar(10),sage datetime,ssex nvarchar(10)) insert into student values(01 , N赵雷 , 1990-01-01 , N男) insert into student values(02 , N钱电 , 1990-12-21 , N男) insert into student values(03 , N孙风 , 1990-05-20 , N男) insert into student values(04 , N李云 , 1990-08-06 , N男) insert into student values(05 , N周梅 , 1991-12-01 , N女) insert into student values(06 , N吴兰 , 1992-