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 |