Description
</para></entry>
</row>
</thead>
<tbody>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>sizing_id</structfield> <type>cardinal_number</type>
</para>
<para>
Identifier of the sizing item
</para></entry>
</row>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>sizing_name</structfield> <type>character_data</type>
</para>
<para>
Descriptive name of the sizing item
</para></entry>
</row>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>supported_value</structfield> <type>cardinal_number</type>
</para>
<para>
Value of the sizing item, or 0 if the size is unlimited or
cannot be determined, or null if the features for which the
sizing item is applicable are not supported
</para></entry>
</row>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>comments</structfield> <type>character_data</type>
</para>
<para>
Possibly a comment pertaining to the sizing item
</para></entry>
</row>
</tbody>
</tgroup>
</table>
</sect1>
<sect1 id="infoschema-table-constraints">
<title><literal>table_constraints</literal></title>
<para>
The view <literal>table_constraints</literal> contains all
constraints belonging to tables that the current user owns or has
some privilege other than <literal>SELECT</literal> on.
</para>
<table>
<title><structname>table_constraints</structname> Columns</title>
<tgroup cols="1">
<thead>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
Column Type
</para>
<para>
Description
</para></entry>
</row>
</thead>
<tbody>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>constraint_catalog</structfield> <type>sql_identifier</type>
</para>
<para>
Name of the database that contains the constraint (always the current database)
</para></entry>
</row>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>constraint_schema</structfield> <type>sql_identifier</type>
</para>
<para>
Name of the schema that contains the constraint
</para></entry>
</row>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>constraint_name</structfield> <type>sql_identifier</type>
</para>
<para>
Name of the constraint
</para></entry>
</row>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>table_catalog</structfield> <type>sql_identifier</type>
</para>
<para>
Name of the database that contains the table (always the current database)
</para></entry>
</row>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>table_schema</structfield> <type>sql_identifier</type>
</para>
<para>
Name of the schema that contains the table
</para></entry>
</row>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>table_name</structfield> <type>sql_identifier</type>
</para>
<para>
Name of the table
</para></entry>
</row>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>constraint_type</structfield> <type>character_data</type>
</para>
<para>
Type of the constraint: <literal>CHECK</literal> (includes not-null constraints),
<literal>FOREIGN KEY</literal>, <literal>PRIMARY KEY</literal>,
or <literal>UNIQUE</literal>
</para></entry>