Stay organized with collections Save and categorize content based on your preferences.
Methods Method Return type Brief descriptiongetCatalogName(column)
String
For documentation of this method, see java.sql.ResultSetMetaData#getCatalogName(int)
. getColumnClassName(column)
String
For documentation of this method, see java.sql.ResultSetMetaData#getColumnClassName(int)
. getColumnCount()
Integer
For documentation of this method, see java.sql.ResultSetMetaData#getColumnCount()
. getColumnDisplaySize(column)
Integer
For documentation of this method, see java.sql.ResultSetMetaData#getColumnDisplaySize(int)
. getColumnLabel(column)
String
For documentation of this method, see java.sql.ResultSetMetaData#getColumnLabel(int)
. getColumnName(column)
String
For documentation of this method, see java.sql.ResultSetMetaData#getColumnName(int)
. getColumnType(column)
Integer
For documentation of this method, see java.sql.ResultSetMetaData#getColumnType(int)
. getColumnTypeName(column)
String
For documentation of this method, see java.sql.ResultSetMetaData#getColumnTypeName(int)
. getPrecision(column)
Integer
For documentation of this method, see java.sql.ResultSetMetaData#getPrecision(int)
. getScale(column)
Integer
For documentation of this method, see java.sql.ResultSetMetaData#getScale(int)
. getSchemaName(column)
String
For documentation of this method, see java.sql.ResultSetMetaData#getSchemaName(int)
. getTableName(column)
String
For documentation of this method, see java.sql.ResultSetMetaData#getTableName(int)
. isAutoIncrement(column)
Boolean
For documentation of this method, see java.sql.ResultSetMetaData#isAutoIncrement(int)
. isCaseSensitive(column)
Boolean
For documentation of this method, see java.sql.ResultSetMetaData#isCaseSensitive(int)
. isCurrency(column)
Boolean
For documentation of this method, see java.sql.ResultSetMetaData#isCurrency(int)
. isDefinitelyWritable(column)
Boolean
For documentation of this method, see java.sql.ResultSetMetaData#isDefinitelyWritable(int)
. isNullable(column)
Integer
For documentation of this method, see java.sql.ResultSetMetaData#isNullable(int)
. isReadOnly(column)
Boolean
For documentation of this method, see java.sql.ResultSetMetaData#isReadOnly(int)
. isSearchable(column)
Boolean
For documentation of this method, see java.sql.ResultSetMetaData#isSearchable(int)
. isSigned(column)
Boolean
For documentation of this method, see java.sql.ResultSetMetaData#isSigned(int)
. isWritable(column)
Boolean
For documentation of this method, see java.sql.ResultSetMetaData#isWritable(int)
. Detailed documentation getCatalogName(column)
For documentation of this method, see java.sql.ResultSetMetaData#getCatalogName(int)
.
column
Integer
The index of the column to examine (the first column is 1, the second is 2, and so on). Return
String
— The catalog name for the table in the designated column, or an empty string if not applicable.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_request
getColumnClassName(column)
For documentation of this method, see java.sql.ResultSetMetaData#getColumnClassName(int)
.
column
Integer
The index of the column to examine (the first column is 1, the second is 2, and so on). Return
String
— The fully-qualified name of the class of the designated column's values.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_request
getColumnCount()
For documentation of this method, see java.sql.ResultSetMetaData#getColumnCount()
.
Integer
— The number of columns in this result set.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_request
getColumnDisplaySize(column)
For documentation of this method, see java.sql.ResultSetMetaData#getColumnDisplaySize(int)
.
column
Integer
The index of the column to examine (the first column is 1, the second is 2, and so on). Return
Integer
— The maximum number of characters allowed as the width of the designated columns.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_request
getColumnLabel(column)
For documentation of this method, see java.sql.ResultSetMetaData#getColumnLabel(int)
.
column
Integer
The index of the column to examine (the first column is 1, the second is 2, and so on). Return
String
— The designated column's suggested title, usually specifed by a SQL AS
clause. Returns the same as getColumnName(column)
if an AS
is not specified.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_request
getColumnName(column)
For documentation of this method, see java.sql.ResultSetMetaData#getColumnName(int)
.
column
Integer
The index of the column to examine (the first column is 1, the second is 2, and so on). Return
String
— The designated column's name.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_request
getColumnType(column)
For documentation of this method, see java.sql.ResultSetMetaData#getColumnType(int)
.
column
Integer
The index of the column to examine (the first column is 1, the second is 2, and so on). Return
Integer
— The SQL type of the designated column.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_request
getColumnTypeName(column)
For documentation of this method, see java.sql.ResultSetMetaData#getColumnTypeName(int)
.
column
Integer
The index of the column to examine (the first column is 1, the second is 2, and so on). Return
String
— The designated column's database-specific type name. Returns the fully-qualifed type name if this is a user-defined type.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_request
getPrecision(column)
For documentation of this method, see java.sql.ResultSetMetaData#getPrecision(int)
.
column
Integer
The index of the column to examine (the first column is 1, the second is 2, and so on). Return
Integer
— The maximum column size for the given column. For numeric data, this is the maximum precision. For character data, this is the length in characters. For datetime data, this is the length in characters of the string representation (assuming the maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID
datatype, this is the length in bytes. Returns 0 for types where the column size is not applicable.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_request
getScale(column)
For documentation of this method, see java.sql.ResultSetMetaData#getScale(int)
.
column
Integer
The index of the column to examine (the first column is 1, the second is 2, and so on). Return
Integer
— The designated columns's number of digits to right of the decimal point. Returns 0 for data types where the scale is not applicable.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_request
getSchemaName(column)
For documentation of this method, see java.sql.ResultSetMetaData#getSchemaName(int)
.
column
Integer
The index of the column to examine (the first column is 1, the second is 2, and so on). Return
String
— The table schema of the designated column.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_request
getTableName(column)
For documentation of this method, see java.sql.ResultSetMetaData#getTableName(int)
.
column
Integer
The index of the column to examine (the first column is 1, the second is 2, and so on). Return
String
— The table name of the designated column, or an empty string if not applicable.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_request
isAutoIncrement(column)
For documentation of this method, see java.sql.ResultSetMetaData#isAutoIncrement(int)
.
column
Integer
The index of the column to examine (the first column is 1, the second is 2, and so on). Return
Boolean
— true
if the specified column is automatically numbered; false
otherwise.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_request
isCaseSensitive(column)
For documentation of this method, see java.sql.ResultSetMetaData#isCaseSensitive(int)
.
column
Integer
The index of the column to examine (the first column is 1, the second is 2, and so on). Return
Boolean
— true
if the specified column is case-sensitive; false
otherwise.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_request
isCurrency(column)
For documentation of this method, see java.sql.ResultSetMetaData#isCurrency(int)
.
column
Integer
The index of the column to examine (the first column is 1, the second is 2, and so on). Return
Boolean
— true
if the specified column is a cash value; false
otherwise.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_request
isDefinitelyWritable(column)
For documentation of this method, see java.sql.ResultSetMetaData#isDefinitelyWritable(int)
.
column
Integer
The index of the column to examine (the first column is 1, the second is 2, and so on). Return
Boolean
— true
if writes to the designated column definitely succeed; false
otherwise.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_request
isNullable(column)
For documentation of this method, see java.sql.ResultSetMetaData#isNullable(int)
.
column
Integer
The index of the column to examine (the first column is 1, the second is 2, and so on). Return
Integer
— The nullability status of the specified column, which is Jdbc.ResultSetMetaData.columnNoNulls
, Jdbc.ResultSetMetaData.columnNullable
, or Jdbc.ResultSetMetaData.columnNullableUnknown
.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_request
isReadOnly(column)
For documentation of this method, see java.sql.ResultSetMetaData#isReadOnly(int)
.
column
Integer
The index of the column to examine (the first column is 1, the second is 2, and so on). Return
Boolean
— true
if the designated column is definitely non-writable; false
otherwise.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_request
isSearchable(column)
For documentation of this method, see java.sql.ResultSetMetaData#isSearchable(int)
.
column
Integer
The index of the column to examine (the first column is 1, the second is 2, and so on). Return
Boolean
— true
if a where clause can use the specified column; false
otherwise.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_request
isSigned(column)
For documentation of this method, see java.sql.ResultSetMetaData#isSigned(int)
.
column
Integer
The index of the column to examine (the first column is 1, the second is 2, and so on). Return
Boolean
— true
if the values in the specified column are signed numbers; false
otherwise.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_request
isWritable(column)
For documentation of this method, see java.sql.ResultSetMetaData#isWritable(int)
.
column
Integer
The index of the column to examine (the first column is 1, the second is 2, and so on). Return
Boolean
— true
if it is possible to write to the designated column; false
otherwise.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_request
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-12-03 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-12-03 UTC."],[[["`JdbcResultSetMetaData` in Google Apps Script provides methods to retrieve information about the columns in a SQL result set, mirroring the `java.sql.ResultSetMetaData` interface in Java."],["You can get details such as column name, type, size, nullability, and other properties using its various methods."],["Methods like `isSearchable()`, `isSigned()`, and `isWritable()` provide insights into the characteristics of specific columns."],["Most methods require a `column` parameter indicating the column index (starting from 1)."],["Using `JdbcResultSetMetaData` requires authorization with the `https://www.googleapis.com/auth/script.external_request` scope in your Google Apps Script project."]]],[]]
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4