📄 databasemetadata.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Frameset//EN""http://www.w3.org/TR/REC-html40/frameset.dtd"><!--NewPage--><HTML><HEAD><!-- Generated by javadoc on Thu Apr 27 23:36:20 PDT 2000 --><TITLE>Java 2 Platform SE v1.3: Interface DatabaseMetaData</TITLE><LINK REL ="stylesheet" TYPE="text/css" HREF="../../stylesheet.css" TITLE="Style"></HEAD><BODY BGCOLOR="white"><!-- ========== START OF NAVBAR ========== --><A NAME="navbar_top"><!-- --></A><TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0"><TR><TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1"><A NAME="navbar_top_firstrow"><!-- --></A><TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3"> <TR ALIGN="center" VALIGN="top"> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A> </TD> <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="class-use/DatabaseMetaData.html"><FONT CLASS="NavBarFont1"><B>Use</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../index-files/index-1.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A> </TD> </TR></TABLE></TD><TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM><b>Java<sup><font size=-2>TM</font></sup> 2 Platform<br>Std. Ed. v1.3</b></EM></TD></TR><TR><TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> <A HREF="../../java/sql/Connection.html"><B>PREV CLASS</B></A> <A HREF="../../java/sql/Driver.html"><B>NEXT CLASS</B></A></FONT></TD><TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> <A HREF="../../index.html" TARGET="_top"><B>FRAMES</B></A> <A HREF="DatabaseMetaData.html" TARGET="_top"><B>NO FRAMES</B></A></FONT></TD></TR><TR><TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2"> SUMMARY: INNER | <A HREF="#field_summary">FIELD</A> | CONSTR | <A HREF="#method_summary">METHOD</A></FONT></TD><TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">DETAIL: <A HREF="#field_detail">FIELD</A> | CONSTR | <A HREF="#method_detail">METHOD</A></FONT></TD></TR></TABLE><!-- =========== END OF NAVBAR =========== --><HR><!-- ======== START OF CLASS DATA ======== --><H2><FONT SIZE="-1">java.sql</FONT><BR>Interface DatabaseMetaData</H2><HR><DL><DT>public interface <B>DatabaseMetaData</B></DL><P>Comprehensive information about the database as a whole. <P>Many of the methods here return lists of information in the form of <code>ResultSet</code> objects. You can use the normal <code>ResultSet</code> methods such as getString and getInt to retrieve the data from these <code>ResultSet</code>. If a given form of metadata is not available, these methods should throw an SQLException. <P>Some of these methods take arguments that are String patterns. These arguments all have names such as fooPattern. Within a pattern String, "%" means match any substring of 0 or more characters, and "_" means match any one character. Only metadata entries matching the search pattern are returned. If a search pattern argument is set to a null ref, that argument's criteria will be dropped from the search. <P>An <code>SQLException</code> will be thrown if a driver does not support a meta data method. In the case of methods that return a <code>ResultSet</code>, either a <code>ResultSet</code> (which may be empty) is returned or a SQLException is thrown.<P><HR><P><!-- ======== INNER CLASS SUMMARY ======== --><!-- =========== FIELD SUMMARY =========== --><A NAME="field_summary"><!-- --></A><TABLE BORDER="1" CELLPADDING="3" CELLSPACING="0" WIDTH="100%"><TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"><TD COLSPAN=2><FONT SIZE="+2"><B>Field Summary</B></FONT></TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static int</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#bestRowNotPseudo">bestRowNotPseudo</A></B></CODE><BR> Indicates that the best row identifier is NOT a pseudo column.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static int</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#bestRowPseudo">bestRowPseudo</A></B></CODE><BR> Indicates that the best row identifier is a pseudo column.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static int</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#bestRowSession">bestRowSession</A></B></CODE><BR> Indicates that the scope of the best row identifier is the remainder of the current session.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static int</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#bestRowTemporary">bestRowTemporary</A></B></CODE><BR> Indicates that the scope of the best row identifier is very temporary, lasting only while the row is being used.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static int</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#bestRowTransaction">bestRowTransaction</A></B></CODE><BR> Indicates that the scope of the best row identifier is the remainder of the current transaction.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static int</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#bestRowUnknown">bestRowUnknown</A></B></CODE><BR> Indicates that the best row identifier may or may not be a pseudo column.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static int</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#columnNoNulls">columnNoNulls</A></B></CODE><BR> Indicates that the column might not allow NULL values.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static int</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#columnNullable">columnNullable</A></B></CODE><BR> Indicates that the column definitely allows <code>NULL</code> values.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static int</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#columnNullableUnknown">columnNullableUnknown</A></B></CODE><BR> Indicates that the nullability of columns is unknown.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static int</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#importedKeyCascade">importedKeyCascade</A></B></CODE><BR> A possible value for the columns <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> in the <code>ResultSet</code> objects returned by the methods <code>getImportedKeys</code>, <code>getExportedKeys</code>, and <code>getCrossReference</code>.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static int</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#importedKeyInitiallyDeferred">importedKeyInitiallyDeferred</A></B></CODE><BR> A possible value for the column <code>DEFERRABILITY</code> in the <code>ResultSet</code> objects returned by the methods <code>getImportedKeys</code>, <code>getExportedKeys</code>, and <code>getCrossReference</code>.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static int</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#importedKeyInitiallyImmediate">importedKeyInitiallyImmediate</A></B></CODE><BR> A possible value for the column <code>DEFERRABILITY</code> in the <code>ResultSet</code> objects returned by the methods <code>getImportedKeys</code>, <code>getExportedKeys</code>, and <code>getCrossReference</code>.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static int</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#importedKeyNoAction">importedKeyNoAction</A></B></CODE><BR> A possible value for the columns <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> in the <code>ResultSet</code> objects returned by the methods <code>getImportedKeys</code>, <code>getExportedKeys</code>, and <code>getCrossReference</code>.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static int</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#importedKeyNotDeferrable">importedKeyNotDeferrable</A></B></CODE><BR> A possible value for the column <code>DEFERRABILITY</code> in the <code>ResultSet</code> objects returned by the methods <code>getImportedKeys</code>, <code>getExportedKeys</code>, and <code>getCrossReference</code>.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static int</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#importedKeyRestrict">importedKeyRestrict</A></B></CODE><BR> A possible value for the columns <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> in the <code>ResultSet</code> objects returned by the methods <code>getImportedKeys</code>, <code>getExportedKeys</code>, and <code>getCrossReference</code>.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static int</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#importedKeySetDefault">importedKeySetDefault</A></B></CODE><BR> A possible value for the columns <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> in the <code>ResultSet</code> objects returned by the methods
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -