met_conn_openschema.asp

W3Schools tutorial..web designing

        <td valign="top">adSchemaIndexes</td>
        <td valign="top">12</td>
        <td valign="top">Returns the indexes defined in the catalog
        </td>
        <td valign="top">TABLE_CATALOG<br />
          TABLE_SCHEMA<br />
          INDEX_NAME<br />
          TYPE<br />
          TABLE_NAME</td>
      </tr>
      <tr>
        <td valign="top">adSchemaColumnPrivileges</td>
        <td valign="top">13</td>
        <td valign="top">Returns the privileges on columns of tables defined in
          the catalog
        </td>
        <td valign="top">TABLE_CATALOG<br />
          TABLE_SCHEMA<br />
          TABLE_NAME<br />
          COLUMN_NAME<br />
          GRANTOR<br />
          GRANTEE</td>
      </tr>
      <tr>
        <td valign="top">adSchemaTablePrivileges</td>
        <td valign="top">14</td>
        <td valign="top">Returns the privileges on tables defined in the catalog
        </td>
        <td valign="top">TABLE_CATALOG<br />
          TABLE_SCHEMA<br />
          TABLE_NAME<br />
          GRANTOR<br />
          GRANTEE</td>
      </tr>
      <tr>
        <td valign="top">adSchemaUsagePrivileges</td>
        <td valign="top">15</td>
        <td valign="top">Returns the USAGE privileges on objects defined in the
          catalog
        </td>
        <td valign="top">OBJECT_CATALOG<br />
          OBJECT_SCHEMA<br />
          OBJECT_NAME<br />
          OBJECT_TYPE<br />
          GRANTOR<br />
          GRANTEE</td>
      </tr>
      <tr>
        <td valign="top">adSchemaProcedures</td>
        <td valign="top">16</td>
        <td valign="top">Returns the procedures defined in the catalog
        </td>
        <td valign="top">PROCEDURE_CATALOG<br />
          PROCEDURE_SCHEMA<br />
          PROCEDURE_NAME<br />
          PROCEDURE_TYPE</td>
      </tr>
      <tr>
        <td valign="top">adSchemaSchemata</td>
        <td valign="top">17</td>
        <td valign="top">Returns the schemas (database objects)
        </td>
        <td valign="top">CATALOG_NAME<br />
          SCHEMA_NAME<br />
          SCHEMA_OWNER</td>
      </tr>
      <tr>
        <td valign="top">adSchemaSQLLanguages</td>
        <td valign="top">18</td>
        <td valign="top">Returns the conformance levels, options, and dialects
          supported by the SQL-implementation processing data defined in the
          catalog.
        </td>
        <td valign="top">None</td>
      </tr>
      <tr>
        <td valign="top">adSchemaStatistics</td>
        <td valign="top">19</td>
        <td valign="top">Returns the statistics defined in the catalog
        </td>
        <td valign="top">TABLE_CATALOG<br />
          TABLE_SCHEMA<br />
          TABLE_NAME</td>
      </tr>
      <tr>
        <td valign="top">adSchemaTables</td>
        <td valign="top">20</td>
        <td valign="top">Returns the tables defined in the
          catalog that are accessible
        </td>
        <td valign="top">TABLE_CATALOG<br />
          TABLE_SCHEMA<br />
          TABLE_NAME<br />
          TABLE_TYPE</td>
      </tr>
      <tr>
        <td valign="top">adSchemaTranslations</td>
        <td valign="top">21</td>
        <td valign="top">Returns the character translations defined in the
          catalog that are accessible
        </td>
        <td valign="top">TRANSLATION_CATALOG<br />
          TRANSLATION_SCHEMA<br />
          TRANSLATION_NAME</td>
      </tr>
      <tr>
        <td valign="top">adSchemaProviderTypes</td>
        <td valign="top">22</td>
        <td valign="top">Returns the data types supported by the data provider
        </td>
        <td valign="top">DATA_TYPE<br />
          BEST_MATCH</td>
      </tr>
      <tr>
        <td valign="top">adSchemaViews</td>
        <td valign="top">23</td>
        <td valign="top">Returns the views defined in the catalog that are
          accessible
        </td>
        <td valign="top">TABLE_CATALOG<br />
          TABLE_SCHEMA<br />
          TABLE_NAME</td>
      </tr>
      <tr>
        <td valign="top">adSchemaViewColumnUsage</td>
        <td valign="top">24</td>
        <td valign="top">Returns the columns on which viewed tables, are
          dependent
        </td>
        <td valign="top">VIEW_CATALOG<br />
          VIEW_SCHEMA<br />
          VIEW_NAME</td>
      </tr>
      <tr>
        <td valign="top">adSchemaViewTableUsage</td>
        <td valign="top">25</td>
        <td valign="top">Returns the tables on which viewed tables, are
          dependent
        </td>
        <td valign="top">VIEW_CATALOG<br />
          VIEW_SCHEMA<br />
          VIEW_NAME</td>
      </tr>
      <tr>
        <td valign="top">adSchemaProcedureParameters</td>
        <td valign="top">26</td>
        <td valign="top">Returns info about the parameters and return
          codes of procedures
        </td>
        <td valign="top">PROCEDURE_CATALOG<br />
          PROCEDURE_SCHEMA<br />
          PROCEDURE_NAME<br />
          PARAMETER_NAME</td>
      </tr>
      <tr>
        <td valign="top">adSchemaForeignKeys</td>
        <td valign="top">27</td>
        <td valign="top">Returns the foreign key columns defined in the catalog
        </td>
        <td valign="top">PK_TABLE_CATALOG<br />
          PK_TABLE_SCHEMA<br />
          PK_TABLE_NAME<br />
          FK_TABLE_CATALOG<br />
          FK_TABLE_SCHEMA<br />
          FK_TABLE_NAME</td>
      </tr>
      <tr>
        <td valign="top">adSchemaPrimaryKeys</td>
        <td valign="top">28</td>
        <td valign="top">Returns the primary key columns defined in the catalog
        </td>
        <td valign="top">PK_TABLE_CATALOG<br />
          PK_TABLE_SCHEMA<br />
          PK_TABLE_NAME</td>
      </tr>
      <tr>
        <td valign="top">adSchemaProcedureColumns</td>
        <td valign="top">29</td>
        <td valign="top">Returns info about the columns of rowsets
          returned by procedures
        </td>
        <td valign="top">PROCEDURE_CATALOG<br />
          PROCEDURE_SCHEMA<br />
          PROCEDURE_NAME<br />
          COLUMN_NAME</td>
      </tr>
      <tr>
        <td valign="top">adSchemaDBInfoKeywords</td>
        <td valign="top">30</td>
        <td valign="top">Returns a list of provider-specific keywords
        </td>
        <td valign="top">None</td>
      </tr>
      <tr>
        <td valign="top">adSchemaDBInfoLiterals</td>
        <td valign="top">31</td>
        <td valign="top">Returns a list of provider-specific literals used in
          text commands
        </td>
        <td valign="top">None</td>
      </tr>
      <tr>
        <td valign="top">adSchemaCubes</td>
        <td valign="top">32</td>
        <td valign="top">Returns info about the available cubes in a
          schema
        </td>
        <td valign="top">CATALOG_NAME<br />
          SCHEMA_NAME<br />
          CUBE_NAME</td>
      </tr>
      <tr>
        <td valign="top">adSchemaDimensions</td>
        <td valign="top">33</td>
        <td valign="top">Returns info about the dimensions in a given cube
        </td>
        <td valign="top">CATALOG_NAME<br />
          SCHEMA_NAME<br />
          CUBE_NAME<br />
          DIMENSION_NAME<br />
          DIMENSION_UNIQUE_NAME</td>
      </tr>
      <tr>
        <td valign="top">adSchemaHierarchies</td>
        <td valign="top">34</td>
        <td valign="top">Returns info about the hierarchies available in a
          dimension
        </td>
        <td valign="top">CATALOG_NAME<br />
          SCHEMA_NAME<br />
          CUBE_NAME<br />
          DIMENSION_UNIQUE_NAME<br />
          HIERARCHY_NAME<br />
          HIERARCHY_UNIQUE_NAME</td>
      </tr>
      <tr>
        <td valign="top">adSchemaLevels</td>
        <td valign="top">35</td>
        <td valign="top">Returns info about the levels available in a dimension
        </td>
        <td valign="top">CATALOG_NAME<br />
          SCHEMA_NAME<br />
          CUBE_NAME<br />
          DIMENSION_UNIQUE_NAME<br />
          HIERARCHY_UNIQUE_NAME<br />
          LEVEL_NAME<br />
          LEVEL_UNIQUE_NAME</td>
      </tr>
      <tr>
        <td valign="top">adSchemaMeasures</td>
        <td valign="top">36</td>
        <td valign="top">Returns info about the available measures
        </td>
        <td valign="top">CATALOG_NAME<br />
          SCHEMA_NAME<br />
          CUBE_NAME<br />
          MEASURE_NAME<br />
          MEASURE_UNIQUE_NAME</td>
      </tr>
      <tr>
        <td valign="top">adSchemaProperties</td>
        <td valign="top">37</td>
        <td valign="top">Returns info about the available properties for
          each level of the dimension
        </td>
        <td valign="top">CATALOG_NAME<br />
          SCHEMA_NAME<br />
          CUBE_NAME<br />
          DIMENSION_UNIQUE_NAME<br />
          HIERARCHY_UNIQUE_NAME<br />
          LEVEL_UNIQUE_NAME<br />
          MEMBER_UNIQUE_NAME<br />
          PROPERTY_TYPE<br />
          PROPERTY_NAME</td>
      </tr>
      <tr>
        <td valign="top">adSchemaMembers</td>
        <td valign="top">38</td>
        <td valign="top">Returns info about the available members
        </td>
        <td valign="top">CATALOG_NAME<br />
          SCHEMA_NAME<br />
          CUBE_NAME<br />
          DIMENSION_UNIQUE_NAME<br />
          HIERARCHY_UNIQUE_NAME<br />
          LEVEL_UNIQUE_NAME<br />
          LEVEL_NUMBER<br />
          MEMBER_NAME<br />
          MEMBER_UNIQUE_NAME<br />
          MEMBER_CAPTION<br />
          MEMBER_TYPE<br />
          TREE OPERATOR</td>
      </tr>
      <tr>
        <td valign="top">adSchemaTrustees</td>
        <td valign="top">39</td>
        <td valign="top">For future use</td>
        <td valign="top">None</td>
      </tr>
  </table>
<br />
<hr />
<a href="ado_ref_connection.asp"><img class="navup" src="../images/up.gif" alt="Connection Object Reference" border="0" /> Complete Connection Object Reference</a>

<br />
<hr />

<!-- **** SPOTLIGHTS 1 **** -->

<iframe src="../banners/aspallframe.asp" height="110" width="485"
marginwidth="0" marginheight="0" frameborder="0" scrolling="no">
Your browser does not support inline frames or is currently configured not to display inline frames.
</iframe>
<hr />
<!-- **** SPOTLIGHTS 2 **** -->

<h2><a target="_blank" href="../../www.altova.com/ref/@s=w3s_spotlight&q=xmlspy">
Altova