CA IDMS/DB SQL Dictionary Reports—QREPORTS › QREPORT 003 -Schema and Table Report

QREPORT 003 -Schema and Table Report

QREPORT 003, the Schema and Table Report, provides a one page detailed listing of each SQL schema that in a dictionary. It also includes summary information about each table that belongs to the schema.

Not all schemas have associated tables. Therefore, QREPORT 003 uses an SQL "outer join" to provide information about all SQL schemas in the dictionary.