数据库系统及应用实验与课程设计指导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)