`
zealotds
  • 浏览: 119615 次
  • 性别: Icon_minigender_1
  • 来自: 西安
社区版块
存档分类
最新评论

SQL Server 2008 Information Schema Views

阅读更多
tag: sql server 2008 metadata view

标记备忘

Information Schema View属于System Views.
包含以下试图,对表单的元数据查询很有帮助:

  • CHECK_CONSTRAINTS
  • COLUMN_DOMAIN_USAGE
  • COLUMN_PRIVILEGES
  • COLUMNS
  • CONSTRAINT_COLUMN_USAGE
  • CONSTRAINT_TABLE_USAGE
  • DOMAIN_CONSTRAINTS
  • DOMAINS
  • KEY_COLUMN_USAGE
  • PARAMETERS
  • REFERENTIAL_CONSTRAINTS
  • ROUTINES
  • ROUTINE_COLUMNS
  • SCHEMATA
  • TABLE_CONSTRAINTS
  • TABLE_PRIVILEGES
  • TABLES
  • VIEW_COLUMN_USAGE
  • VIEW_TABLE_USAGE
  • VIEWS


System Views还包含了以下几个类别:
  • Catalog Views
  • Compatibility Views
  • Dynamic Management Views and Functions
  • Information Schema Views
  • Replication Views



分享到:
评论

相关推荐

    Beginning T-SQL with Microsoft SQL Server 2005 and 2008

    The book concludes with a comprehensive set of reference appendixes for command syntax, system stored procedures, information schema views, file system commands, and system management commands. ...

    Beginning Transact-SQL with SQL Server 2000 and 2005 (4 of 5)

    Beginning Transact-SQL with SQL Server 2000 and 2005 ...Appendix C - System Stored Procedure Reference Appendix D - Information Schema Views Reference Appendix E - Answers to Exercises

    Beginning Transact-SQL with SQL Server 2000 and 2005 (2 of 5)

    Beginning Transact-SQL with SQL Server 2000 and 2005 byPaul TurleyandDan Wood Wrox Press 2006 (594 pages)... Appendix D - Information Schema Views Reference Appendix E - Answers to Exercises Index

    Beginning Transact-SQL with SQL Server 2000 and 2005 (1 of 5)

    Beginning Transact-SQL with SQL... Appendix D - Information Schema Views Reference Appendix E - Answers to Exercises 英文,电驴上下载的,希望对大家有些用处。 由于这里不能上传太大的文件,分成5块上传。

    Beginning Transact-SQL with SQL Server 2000 and 2005 (5 of 5)

    Beginning Transact-SQL with SQL Server 2000 and 2005 ...Appendix C - System Stored Procedure Reference Appendix D - Information Schema Views Reference Appendix E - Answers to Exercises

    Beginning Transact-SQL with SQL Server 2000 and 2005 (3 of 5)

    Beginning Transact-SQL with SQL ...Appendix C - System Stored Procedure Reference Appendix D - Information Schema Views Reference Appendix E - Answers to Exercises Index 第三部分 of 5

    微软内部资料-SQL性能优化5

    Indexes in SQL Server store their information using standard B-trees. A B-tree provides fast access to data by searching on a key value of the index. B-trees cluster records with similar keys. The B ...

    Oracle Security

    The User Interface: User Versus Schema Objects Tables Table Triggers Views Stored Programs Synonyms Privileges Roles Profiles Chapter 4 The Oracle Data Dictionary Creating and Maintaining ...

    最完整的Toad For Oracle使用手册

    Export Tables, Views, SQL Queries from the Command Line 744 Run Analyze Objects from the Command Line 745 Run CodeXpert from the Command Line 750 Running Actions from the Command Line 751 Run Compare ...

    数据库系统概念Database System Concept(英文第6版)文字版

    Database System Concepts——数据库系统概念第六版(英文版) 作者: Abraham Silberschatz (Yale University)...30.12 SQL Server Service Broker 1261 30.13 Business Intelligence 1263 Bibliographical Notes 1267

    oracle概念手册中英文对照版

    Chapter 24, SQL, PL/SQL, and Java 第 24 章,SQL,PL/SQL,及 Java Chapter 25, Overview of Application Development Languages 第 25 章,应用程序开发语言概述 Chapter 26, Native Datatypes 第 26 章,原生...

    mysql官方中文参考手册

    5.1.4. mysql.server:MySQL服务器启动脚本 5.1.5. mysqld_multi:管理多个MySQL服务器的程序 5.2. mysqlmanager:MySQL实例管理器 5.2.1. 用MySQL实例管理器启动MySQL服务器 5.2.2. 连接到MySQL实例管理器并创建...

    MYSQL中文手册

    5.1.4. mysql.server:MySQL服务器启动脚本 5.1.5. mysqld_multi:管理多个MySQL服务器的程序 5.2. mysqlmanager:MySQL实例管理器 5.2.1. 用MySQL实例管理器启动MySQL服务器 5.2.2. 连接到MySQL实例管理器并...

    MySQL 5.1中文手冊

    5.1.4. mysql.server:MySQL服务器启动脚本 5.1.5. mysqld_multi:管理多个MySQL服务器的程序 5.2. mysqlmanager:MySQL实例管理器 5.2.1. 用MySQL实例管理器启动MySQL服务器 5.2.2. 连接到MySQL实例管理器并创建...

    MySQL 5.1参考手册中文版

    5.1.4. mysql.server:MySQL服务器启动脚本 5.1.5. mysqld_multi:管理多个MySQL服务器的程序 5.2. mysqlmanager:MySQL实例管理器 5.2.1. 用MySQL实例管理器启动MySQL服务器 5.2.2. 连接到MySQL实例管理器并创建...

    MySQL 5.1参考手册

    5.1.4. mysql.server:MySQL服务器启动脚本 5.1.5. mysqld_multi:管理多个MySQL服务器的程序 5.2. mysqlmanager:MySQL实例管理器 5.2.1. 用MySQL实例管理器启动MySQL服务器 5.2.2. 连接到MySQL实例管理器并创建...

    Oracle Concepts 中英文对照版 (10g R2).rar

    Part I What Is Oracle? 第一部分 何为 Oracle? Chapter 1, Introduction to the Oracle Database 第 1 章,Oracle 数据库简介...Chapter 27, Object Datatypes and Object Views 第 27 章,对象数据类型及对象视图

    oracle concepts概念手册中英文版(10gR2)

    Chapter 24, SQL, PL/SQL, and Java 第 24 章,SQL,PL/SQL,及 Java Chapter 25, Overview of Application Development Languages 第 25 章,应用程序开发语言概述 Chapter 26, Native Datatypes 第 26 章,原生...

    Oracle Concepts 中文版 (10g R2)

    Chapter 24, SQL, PL/SQL, and Java 第 24 章,SQL,PL/SQL,及 Java Chapter 25, Overview of Application Development Languages 第 25 章,应用程序开发语言概述 Chapter 26, Native Datatypes 第 26 章,原生...

Global site tag (gtag.js) - Google Analytics