<HTML><HEAD>
 <title>Index: ASN.IBMSNAP_CAPSCHEMAX</title>
<LINK REL="stylesheet" TYPE="text/css" HREF="./../../style/style.css">
<SCRIPT SRC="./../../style/vs70.js"></SCRIPT>
<SCRIPT SRC="./../../style/vs70link.js"></SCRIPT>
</HEAD><BODY id='bodyID'>
<div id="nsbanner">
<div id="bannerrow1">
<P CLASS="page-header">&nbsp;
<img src="./../../style/index.ico">Index: ASN.IBMSNAP_CAPSCHEMAX</P></div></div>
<DIV id="nstext" valign="bottom">
<p class='page-sub-header'><a name="_Toc2067737418" > Properties</a></p>
<table  border=1 cellpadding=1 cellspacing=1 >
<tr>
  <td valign=top nowrap class='td_header_min'>Name:</td>
  <td>IBMSNAP_CAPSCHEMAX&nbsp;</td>
</tr>
<tr>
  <td valign=top nowrap class='td_header_min'>Schema:</td>
  <td><a href="./../../schema/main/823519054.html">ASN</a>&nbsp;</td>
</tr>
<tr>
  <td valign=top nowrap class='td_header_min'>Table schema:</td>
  <td><a href="./../../schema/main/823519054.html">ASN</a>&nbsp;</td>
</tr>
<tr>
  <td valign=top nowrap class='td_header_min'>Table:</td>
  <td><a href="./../../table/main/1708583070.html">IBMSNAP_CAPSCHEMAS</a>&nbsp;</td>
</tr>
<tr>
  <td valign=top nowrap class='td_header_min'>Unique rule:</td>
  <td>UNIQUE&nbsp;</td>
</tr>
<tr>
  <td valign=top nowrap class='td_header_min'>Type:</td>
  <td>REGULAR&nbsp;</td>
</tr>
<tr>
  <td valign=top nowrap class='td_header_min'>Create time:</td>
  <td>01.07.2006&nbsp;</td>
</tr>
<tr>
  <td valign=top nowrap class='td_header_min'>Tablespace:</td>
  <td><a href="./../../tablespace/main/197214335.html">TSASNCA</a>&nbsp;</td>
</tr>
<tr>
  <td valign=top nowrap class='td_header_min'>Description:</td>
  <td>&nbsp;</td>
</tr>
 </table>
<p class='page-sub-header'><a name="_Toc1691561879" > Columns</a></p>
<table border=1 class='table_list' >
<tr class='tr_header' width='1'>
<td valign=top nowrap><b></b></td>
<td valign=top nowrap><b>Colname</b></td>
<td valign=top nowrap><b>Order</b></td>
</tr>
<tr>
<td valign="top" class="td_min">
<img src="./../../style/column.ico">&nbsp;</td>
<td valign=top>
CAP_SCHEMA_NAME&nbsp;</td>
<td valign=top>
ASCENDING&nbsp;</td>
</tr>
    </table>
<span class="objects_number">Total: 1 column(s)</span>
<p class='page-sub-header'><a name="_Toc806586992" > Autherisations</a></p>
<table border=1 class='table_list' >
<tr class='tr_header' width='1'>
<td valign=top nowrap><b></b></td>
<td valign=top nowrap><b>Grantor</b></td>
<td valign=top nowrap><b>Grantee</b></td>
<td valign=top nowrap><b>Authorities</b></td>
</tr>
<tr>
<td valign="top" class="td_min">
<img src="./../../style/permission.ico">&nbsp;</td>
<td valign=top>
SYSIBM&nbsp;</td>
<td valign=top>
<a href="./../../user/main/63392434.html">USER</a>&nbsp;</td>
<td valign=top>
CONTROL=HELD&nbsp;</td>
</tr>
    </table>
<span class="objects_number">Total: 1 autherisation(s)</span>
<p class='page-sub-header'><a name="_Toc2067737418" > SQL</a></p>
<p class="pre">
<span class=keyword>CREATE</span> <span class=keyword>UNIQUE</span> <span class=keyword>INDEX</span> <span class=string>"ASN&nbsp;&nbsp;&nbsp;&nbsp; "</span>.<span class=string>"IBMSNAP_CAPSCHEMAX"</span> <span class=keyword>ON</span> <span class=string>"ASN&nbsp;&nbsp;&nbsp;&nbsp; "</span>.<span class=string>"IBMSNAP_CAPSCHEMAS"</span> <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(<span class=string>"CAP_SCHEMA_NAME"</span> <span class=keyword>ASC</span>);<br>
</p>
<p class="page-sub-header">See Also</p>
<a class="see_also_href" href="./../../database_indexes_list/main/1379905910.html">List of indexes</a><br>
<br>
<br>
</div>
</body>
</html>