SQL Server INFORMATION_SCHEMA

INFORMATION_SCHEMA视图可以检索数据库中的对象的元数据。您可以直接在当前实例的数据库调用需求的数据。另外值得称好的是，在SQL 2005和SQL 2008这些Information Schema views符合ISO标准。

代码
SELECT * FROM INFORMATION_SCHEMA.CHECK_CONSTRAINTS 
                                 COLUMN_DOMAIN_USAGE 
                                 COLUMN_PRIVILEGES 
                                 COLUMNS 
                                 CONSTRAINT_COLUMN_USAGE 
                                 CONSTRAINT_TABLE_USAGE 
                                 DOMAIN_CONSTRAINTS 
                                 DOMAINS 
                                 KEY_COLUMN_USAGE 
                                 PARAMETERS 
                                 REFERENTIAL_CONSTRAINTS 
                                 ROUTINE_COLUMNS 
                                 ROUTINES 
                                 SCHEMATA 
                                 TABLE_CONSTRAINTS 
                                 TABLE_PRIVILEGES 
                                 TABLES 
                                 VIEW_COLUMN_USAGE 
                                 VIEW_TABLE_USAGE 
                                 VIEWS

 
演示：

posted @ 2010-12-31 13:33  Insus.NET  阅读(1385)  评论(1)  编辑  收藏  举报