<docbook><section><title>UdadocFAQWhatDoesCustomCatalogViewsDo</title><para> </para><title> doc.FAQ.WhatDoesCustomCatalogViewsDo</title> doc.FAQ.WhatDoesCustomCatalogViewsDo
<para> &quot;Custom Catalog Views&quot; controls whether custom <ulink url="OpenLink">OpenLink</ulink>  views are used to return meta-data for some ODBC catalog functions.
 These custom views provide more meta-data than is normally available.
 To create and use them, the script odbccat[8|9].sql must be run beforehand.</para><para>The ODBC catalog functions affected are: <ulink url="SQLForeignKeys">SQLForeignKeys</ulink>  , <ulink url="SQLPrimaryKeys">SQLPrimaryKeys</ulink>  , <ulink url="SQLProcedureColumns">SQLProcedureColumns</ulink>  , SQLProcedures, <ulink url="SQLSpecialColumns">SQLSpecialColumns</ulink></para><para>The odbccat[8|9].sql scripts create the following <ulink url="OpenLink">OpenLink</ulink>  &#39;internal&#39; views: OPENLINK$SQL <emphasis>FOREIGN_KEYS OPENLINK$SQL_PRIMARY_KEYS OPENLINK$SQL_SPEC_COLUMNS OPENLINK$SQL_PROC_COLUMNS OPENLINK$SQL_PROCEDURES OPENLINK$SQL_PROCS_NOCOUNT </emphasis></para><para>If &quot;Custom Catalog Views&quot; is enabled, these internal views will be used.
 Otherwise only standard Oracle data dictionary views are used.</para><para>To run these scripts you need to start the Oracle server manager (svrmgr or sqldba if you do this from the command line).
 Connect as internal and run the script by locating the relevant script file as you would any other Oracle SQL script file.</para><para> </para></section></docbook>