Sams Teach Yourself SQL in 24 Hours
- Table of Contents
- Copyright
- About the Authors
- Acknowledgments
- Tell Us What You Think!
- Introduction
- Part I: A SQL Concepts Overview
- Hour 1. Welcome to the World of SQL
- Part II: Building Your Database
- Hour 2. Defining Data Structures
- Hour 3. Managing Database Objects
- Hour 4. The Normalization Process
- Hour 5. Manipulating Data
- Hour 6. Managing Database Transactions
- Part III: Getting Effective Results from Queries
- Hour 7. Introduction to the Database Query
- Hour 8. Using Operators to Categorize Data
- Hour 9. Summarizing Data Results from a Query
- Hour 10. Sorting and Grouping Data
- Hour 11. Restructuring the Appearance of Data
- Hour 12. Understanding Dates and Times
- Part IV: Building Sophisticated Database Queries
- Hour 13. Joining Tables in Queries
- Hour 14. Using Subqueries to Define Unknown Data
- Hour 15. Combining Multiple Queries into One
- Part V: SQL Performance Tuning
- Hour 16. Using Indexes to Improve Performance
- Hour 17. Improving Database Performance
- Part VI: Using SQL to Manage Users and Security
- Hour 18. Managing Database Users
- Hour 19. Managing Database Security
- Part VII: Summarized Data Structures
- Hour 20. Creating and Using Views and Synonyms
- Hour 21. Working with the System Catalog
- What Is the System Catalog?
- How Is the System Catalog Created?
- What Is Contained in the System Catalog?
- Examples of System Catalog Tables by Implementation
- Querying the System Catalog
- Updating System Catalog Objects
- Summary
- Q&A
- Workshop
- Part VIII: Applying SQL Fundamentals in Today's World
- Hour 22. Advanced SQL Topics
- Hour 23. Extending SQL to the Enterprise, the Internet, and the Intranet
- Hour 24. Extensions to Standard SQL
- Part IX: Appendixes
- Appendix A. Common SQL Commands
- Appendix B. Using MySQL for Exercises
- Appendix C. Answers to Quizzes and Exercises
- Appendix D. CREATE TABLE Statements for Book Examples
- Appendix E. INSERT Statements for Data in Book Examples
- Appendix F. Glossary
- Appendix G. Bonus Exercises
Examples of System Catalog Tables by Implementation
Each implementation has several tables and views that compose the system catalog, some of which are categorized by user level, system level, and DBA level. For your particular implementation, you should query these tables and read your implementation's documentation for more information on system catalog tables. See Table 21.1 for a few examples of five major implementations.
Table 21.1. Major Implementations' System Catalog Objects
|
Microsoft SQL Server |
|
|
Table Name |
Description |
|
SYSUSERS |
Information on database users |
|
SYSSEGMENTS |
Information on all database segments |
|
SYSINDEXES |
Information on all indexes |
|
SYSCONSTRAINTS |
Information on all constraints |
|
dBASE |
|
|
Table Name |
Description |
|
SYSVIEWS |
Information on all views |
|
SYSTABLS |
Information on all tables |
|
SYSIDXS |
Information on all indexes |
|
SYSCOLS |
Information on columns of tables |
|
Microsoft Access |
|
|
Table Name |
Description |
|
MSysColumns |
Information on columns in tables |
|
MSysIndexes |
Information on indexes in tables |
|
MSysMacros |
Information on macros created |
|
MSysObjects |
Information on all database objects |
|
MSysQueries |
Information on queries created |
|
MSysRelationships |
Information on table relationships |
|
Sybase |
|
|
Table Name |
Description |
|
SYSMESSAGES |
Lists all server error messages |
|
SYSKEYS |
Primary and foreign key information |
|
SYSTABLES |
Information on all tables and views |
|
SYSVIEWS |
Text of all views |
|
SYSCOLUMNS |
Information on table columns |
|
SYSINDEXES |
Information on indexes |
|
SYSOBJECTS |
Information on tables, triggers, views, and the like |
|
SYSDATABASES |
Information on all databases on server |
|
SYSPROCEDURES |
Information on views, triggers, and stored procedures |
|
Oracle |
|
|
Table Name |
Description |
|
ALL_TABLES |
Information on tables accessible by a user |
|
USER_TABLES |
Information on tables owned by a user |
|
DBA_TABLES |
Information on all tables in the database |
|
DBA_SEGMENTS |
Information about segment storage |
|
DBA_INDEXES |
Information on all indexes |
|
DBA_USERS |
Information on all users of the database |
|
DBA_ROLE_PRIVS |
Information about roles granted |
|
DBA_ROLES |
Information about roles in the database |
|
DBA_SYS_PRIVS |
Information about system privileges granted |
|
DBA_FREE_SPACE |
Information about database free space |
|
V$DATABASE |
Information about the creation of the database |
|
V$SESSION |
Information on current sessions |
|
MySQL |
|
|
Table Name |
Description |
|
COLUMNS_PRIV |
Information on column privileges |
|
DB |
Information on database privileges |
|
FUNC |
For the management of user-defined functions |
|
HOST |
Information on hostnames related to MySQL |
|
TABLES_PRIV |
Information on table privileges |
|
USER |
Information on table relationships |
Querying the System Catalog | Next Section
Account Sign In
View your cart