mssql2000 数据库结构查询

select 'check_constraints' as check_constraints,* from information_schema.check_constraints
select 'column_domain_usage' as column_domain_usage,* from information_schema.column_domain_usage
select 'column_privileges' as column_privileges,* from information_schema.column_privileges
select 'columns' as columns,* from information_schema.columns
select 'constraint_column_usage' as constraint_column_usage,* from information_schema.constraint_column_usage
select 'constraint_table_usage' as constraint_table_usage,* from information_schema.constraint_table_usage
select 'domain_constraints' as domain_constraints,* from information_schema.domain_constraints
select 'domains' as domains,* from information_schema.domains
select 'key_column_usage' as key_column_usage,* from information_schema.key_column_usage
select 'parameters' as parameters,* from information_schema.parameters
select 'referential_constraints' as referential_constraints,* from information_schema.referential_constraints
select 'routine_columns' as routine_columns,* from information_schema.routine_columns
select 'routines' as routines,* from information_schema.routines
select 'schemata' as schemata,* from information_schema.schemata
select 'table_constraints' as table_constraints,* from information_schema.table_constraints
select 'table_privileges' as table_privileges,* from information_schema.table_privileges
select 'tables' as tables,* from information_schema.tables
select 'view_column_usage' as view_column_usage,* from information_schema.view_column_usage
select 'view_table_usage' as view_table_usage,* from information_schema.view_table_usage
select 'views' as views,* from information_schema.views