手记

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

 
演示:

0人推荐
随时随地看视频
慕课网APP