Examples of System Catalog Tables by Implementation

Team-Fly    

 
Sams Teach Yourself SQL in 24 Hours, Third Edition
By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Hour  21.  Working with the System Catalog


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

graphics/note_icon.gif

These are just a few of the system catalog objects from a few various relational database implementations. Many of the system catalog objects that are similar between implementations are shown here, but this hour strives to provide some variety. Overall, each implementation is very specific to the organization of the system catalog's contents.



Team-Fly    
Top
 


Sams Teach Yourself SQL in 24 Hours
Sams Teach Yourself SQL in 24 Hours (5th Edition) (Sams Teach Yourself -- Hours)
ISBN: 0672335417
EAN: 2147483647
Year: 2002
Pages: 275

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net