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
分享到:
相关推荐
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 ...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 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... Appendix D - Information Schema Views Reference Appendix E - Answers to Exercises 英文,电驴上下载的,希望对大家有些用处。 由于这里不能上传太大的文件,分成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 ...Appendix C - System Stored Procedure Reference Appendix D - Information Schema Views Reference Appendix E - Answers to Exercises Index 第三部分 of 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 ...
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 ...
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 Concepts——数据库系统概念第六版(英文版) 作者: Abraham Silberschatz (Yale University)...30.12 SQL Server Service Broker 1261 30.13 Business Intelligence 1263 Bibliographical Notes 1267
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 章,原生...
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实例管理器并创建...
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实例管理器并...
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实例管理器并创建...
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实例管理器并创建...
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实例管理器并创建...
Part I What Is Oracle? 第一部分 何为 Oracle? Chapter 1, Introduction to the Oracle Database 第 1 章,Oracle 数据库简介...Chapter 27, Object Datatypes and Object Views 第 27 章,对象数据类型及对象视图
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 章,原生...
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 章,原生...