The Information Schema consists of read-only views that provide information about all the tables, views, and columns in the current database server to which you have access. These views also provide information about SQL dialects (such as Informix, Oracle, or Sybase) and SQL standards. Note that unlike a system catalog, whose tables describes an individual database, these views describe the Dynamic Server instance, rather than a single database.
This version of the Information Schema views is an X/Open CAE standard. These standards are provided so that applications developed on other database systems can obtain Informix system catalog information without accessing the Informix system catalog tables directly.
The following Information Schema views are available:
Sections that follow contain information about how to generate and access Information Schema views as well as information about their structure.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]