📄 databasemetadata.html
字号:
<!-- ========== METHOD SUMMARY =========== --><A NAME="method_summary"><!-- --></A><TABLE BORDER="1" CELLPADDING="3" CELLSPACING="0" WIDTH="100%"><TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"><TD COLSPAN=2><FONT SIZE="+2"><B>Method Summary</B></FONT></TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> boolean</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#allProceduresAreCallable()">allProceduresAreCallable</A></B>()</CODE><BR> Can all the procedures returned by getProcedures be called by the current user?</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> boolean</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#allTablesAreSelectable()">allTablesAreSelectable</A></B>()</CODE><BR> Can all the tables returned by getTable be SELECTed by the current user?</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> boolean</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#dataDefinitionCausesTransactionCommit()">dataDefinitionCausesTransactionCommit</A></B>()</CODE><BR> Does a data definition statement within a transaction force the transaction to commit?</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> boolean</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#dataDefinitionIgnoredInTransactions()">dataDefinitionIgnoredInTransactions</A></B>()</CODE><BR> Is a data definition statement within a transaction ignored?</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> boolean</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#deletesAreDetected(int)">deletesAreDetected</A></B>(int type)</CODE><BR> Indicates whether or not a visible row delete can be detected by calling ResultSet.rowDeleted().</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> boolean</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#doesMaxRowSizeIncludeBlobs()">doesMaxRowSizeIncludeBlobs</A></B>()</CODE><BR> Did getMaxRowSize() include LONGVARCHAR and LONGVARBINARY blobs?</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/sql/ResultSet.html">ResultSet</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#getBestRowIdentifier(java.lang.String, java.lang.String, java.lang.String, int, boolean)">getBestRowIdentifier</A></B>(<A HREF="../../java/lang/String.html">String</A> catalog, <A HREF="../../java/lang/String.html">String</A> schema, <A HREF="../../java/lang/String.html">String</A> table, int scope, boolean nullable)</CODE><BR> Gets a description of a table's optimal set of columns that uniquely identifies a row.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/sql/ResultSet.html">ResultSet</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#getCatalogs()">getCatalogs</A></B>()</CODE><BR> Gets the catalog names available in this database.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/lang/String.html">String</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#getCatalogSeparator()">getCatalogSeparator</A></B>()</CODE><BR> What's the separator between catalog and table name?</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/lang/String.html">String</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#getCatalogTerm()">getCatalogTerm</A></B>()</CODE><BR> What's the database vendor's preferred term for "catalog"?</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/sql/ResultSet.html">ResultSet</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#getColumnPrivileges(java.lang.String, java.lang.String, java.lang.String, java.lang.String)">getColumnPrivileges</A></B>(<A HREF="../../java/lang/String.html">String</A> catalog, <A HREF="../../java/lang/String.html">String</A> schema, <A HREF="../../java/lang/String.html">String</A> table, <A HREF="../../java/lang/String.html">String</A> columnNamePattern)</CODE><BR> Gets a description of the access rights for a table's columns.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/sql/ResultSet.html">ResultSet</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#getColumns(java.lang.String, java.lang.String, java.lang.String, java.lang.String)">getColumns</A></B>(<A HREF="../../java/lang/String.html">String</A> catalog, <A HREF="../../java/lang/String.html">String</A> schemaPattern, <A HREF="../../java/lang/String.html">String</A> tableNamePattern, <A HREF="../../java/lang/String.html">String</A> columnNamePattern)</CODE><BR> Gets a description of table columns available in the specified catalog.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/sql/Connection.html">Connection</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#getConnection()">getConnection</A></B>()</CODE><BR> Retrieves the connection that produced this metadata object.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/sql/ResultSet.html">ResultSet</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#getCrossReference(java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String)">getCrossReference</A></B>(<A HREF="../../java/lang/String.html">String</A> primaryCatalog, <A HREF="../../java/lang/String.html">String</A> primarySchema, <A HREF="../../java/lang/String.html">String</A> primaryTable, <A HREF="../../java/lang/String.html">String</A> foreignCatalog, <A HREF="../../java/lang/String.html">String</A> foreignSchema, <A HREF="../../java/lang/String.html">String</A> foreignTable)</CODE><BR> Gets a description of the foreign key columns in the foreign key table that reference the primary key columns of the primary key table (describe how one table imports another's key.) This should normally return a single foreign key/primary key pair (most tables only import a foreign key from a table once.) They are ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and KEY_SEQ.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/lang/String.html">String</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#getDatabaseProductName()">getDatabaseProductName</A></B>()</CODE><BR> What's the name of this database product?</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/lang/String.html">String</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#getDatabaseProductVersion()">getDatabaseProductVersion</A></B>()</CODE><BR> What's the version of this database product?</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> int</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#getDefaultTransactionIsolation()">getDefaultTransactionIsolation</A></B>()</CODE><BR> What's the database's default transaction isolation level? The values are defined in <code>java.sql.Connection</code>.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> int</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#getDriverMajorVersion()">getDriverMajorVersion</A></B>()</CODE><BR> What's this JDBC driver's major version number?</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> int</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#getDriverMinorVersion()">getDriverMinorVersion</A></B>()</CODE><BR> What's this JDBC driver's minor version number?</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/lang/String.html">String</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#getDriverName()">getDriverName</A></B>()</CODE><BR> What's the name of this JDBC driver?</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/lang/String.html">String</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#getDriverVersion()">getDriverVersion</A></B>()</CODE><BR> What's the version of this JDBC driver?</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/sql/ResultSet.html">ResultSet</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#getExportedKeys(java.lang.String, java.lang.String, java.lang.String)">getExportedKeys</A></B>(<A HREF="../../java/lang/String.html">String</A> catalog, <A HREF="../../java/lang/String.html">String</A> schema, <A HREF="../../java/lang/String.html">String</A> table)</CODE><BR> Gets a description of the foreign key columns that reference a table's primary key columns (the foreign keys exported by a table).</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/lang/String.html">String</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#getExtraNameCharacters()">getExtraNameCharacters</A></B>()</CODE><BR> Gets all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _).</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/lang/String.html">String</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#getIdentifierQuoteString()">getIdentifierQuoteString</A></B>()</CODE><BR> What's the string used to quote SQL identifiers? This returns a space " " if identifier quoting isn't supported.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/sql/ResultSet.html">ResultSet</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#getImportedKeys(java.lang.String, java.lang.String, java.lang.String)">getImportedKeys</A></B>(<A HREF="../../java/lang/String.html">String</A> catalog, <A HREF="../../java/lang/String.html">String</A> schema, <A HREF="../../java/lang/String.html">String</A> table)</CODE><BR> Gets a description of the primary key columns that are referenced by a table's foreign key columns (the primary keys imported by a table).</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/sql/ResultSet.html">ResultSet</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/DatabaseMetaData.html#getIndexInfo(java.lang.String, java.lang.String, java.lang.String, boolean, boolean)">getIndexInfo</A></B>(<A HREF="../../java/lang/String.html">String</A> catalog, <A HREF="../../java/lang/String.html">String</A> schema, <A HREF="../../java/lang/String.html">String</A> table, boolean unique, boolean approximate)</CODE>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -