A JDBC Parameter
. For documentation of this class, see java.sql.ParameterMetaData
.
Methods
Method | Return type | Brief description |
---|---|---|
String
|
For documentation of this method, see java.sql.ParameterMetaData#getParameterClassName(int)
. |
|
Integer
|
For documentation of this method, see java.sql.ParameterMetaData#getParameterCount()
. |
|
Integer
|
For documentation of this method, see java.sql.ParameterMetaData#getParameterMode(int)
. |
|
Integer
|
For documentation of this method, see java.sql.ParameterMetaData#getParameterType(int)
. |
|
String
|
For documentation of this method, see java.sql.ParameterMetaData#getParameterTypeName(int)
. |
|
Integer
|
For documentation of this method, see java.sql.ParameterMetaData#getPrecision(int)
. |
|
Integer
|
For documentation of this method, see java.sql.ParameterMetaData#getScale(int)
. |
|
Integer
|
For documentation of this method, see java.sql.ParameterMetaData#isNullable(int)
. |
|
Boolean
|
For documentation of this method, see java.sql.ParameterMetaData#isSigned(int)
. |
Detailed documentation
get
Parameter
Class
Name(param)
For documentation of this method, see java.sql.ParameterMetaData#getParameterClassName(int)
.
Parameters
Name | Type | Description |
---|---|---|
param
|
Integer
|
The index of the parameter to examine. The first parameter has an index of 1. |
Return
String
— The fully-qualified Java class name that is used by the Jdbc
methods.
Authorization
Scripts that use this method require authorization with one or more of the following scopes :
-
https://www.googleapis.com/auth/script.external_request
get
Parameter
Count()
For documentation of this method, see java.sql.ParameterMetaData#getParameterCount()
.
Return
Integer
— The number of parameters for which this metadata contains information.
Authorization
Scripts that use this method require authorization with one or more of the following scopes :
-
https://www.googleapis.com/auth/script.external_request
get
Parameter
Mode(param)
For documentation of this method, see java.sql.ParameterMetaData#getParameterMode(int)
.
Parameters
Name | Type | Description |
---|---|---|
param
|
Integer
|
The index of the parameter to examine. The first parameter has an index of 1. |
Return
Integer
— The designated parameter's mode, which is one of Jdbc.ParameterMetaData.parameterModeIn
, Jdbc.ParameterMetaData.parameterModeOut
, Jdbc.ParameterMetaData.parameterModeInOut
, or Jdbc.ParameterMetaData.parameterModeUnknown
.
Authorization
Scripts that use this method require authorization with one or more of the following scopes :
-
https://www.googleapis.com/auth/script.external_request
get
Parameter
Type(param)
For documentation of this method, see java.sql.ParameterMetaData#getParameterType(int)
.
Parameters
Name | Type | Description |
---|---|---|
param
|
Integer
|
The index of the parameter to examine. The first parameter has an index of 1. |
Return
Integer
— The designated parameter's SQL type
.
Authorization
Scripts that use this method require authorization with one or more of the following scopes :
-
https://www.googleapis.com/auth/script.external_request
get
Parameter
Type
Name(param)
For documentation of this method, see java.sql.ParameterMetaData#getParameterTypeName(int)
.
Parameters
Name | Type | Description |
---|---|---|
param
|
Integer
|
The index of the parameter to examine. The first parameter has an index of 1. |
Return
String
— The designated parameter's database-specific type name. This is a fully-qualified type
name if the parameter is a user-defined type.
Authorization
Scripts that use this method require authorization with one or more of the following scopes :
-
https://www.googleapis.com/auth/script.external_request
get
Precision(param)
For documentation of this method, see java.sql.ParameterMetaData#getPrecision(int)
.
Parameters
Name | Type | Description |
---|---|---|
param
|
Integer
|
The index of the parameter to examine. The first parameter has an index of 1. |
Return
Integer
— The maximum column size for the given parameter. 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.
Authorization
Scripts that use this method require authorization with one or more of the following scopes :
-
https://www.googleapis.com/auth/script.external_request
get
Scale(param)
For documentation of this method, see java.sql.ParameterMetaData#getScale(int)
.
Parameters
Name | Type | Description |
---|---|---|
param
|
Integer
|
The index of the parameter to examine. The first parameter has an index of 1. |
Return
Integer
— The designated parameter's number of digits to right of the decimal point. Returns 0
for data types where the scale is not applicable.
Authorization
Scripts that use this method require authorization with one or more of the following scopes :
-
https://www.googleapis.com/auth/script.external_request
is
Nullable(param)
For documentation of this method, see java.sql.ParameterMetaData#isNullable(int)
.
Parameters
Name | Type | Description |
---|---|---|
param
|
Integer
|
The index of the parameter to examine. The first parameter has an index of 1. |
Return
Integer
— The nullability status of the given parameter; one of Jdbc.ParameterMetaData.parameterNoNulls
, Jdbc.ParameterMetaData.parameterNullable
,
or Jdbc.ParameterMetaData.parameterNullableUnknown
.
Authorization
Scripts that use this method require authorization with one or more of the following scopes :
-
https://www.googleapis.com/auth/script.external_request
is
Signed(param)
For documentation of this method, see java.sql.ParameterMetaData#isSigned(int)
.
Parameters
Name | Type | Description |
---|---|---|
param
|
Integer
|
The index of the parameter to examine. The first parameter has an index of 1. |
Return
Boolean
— true
if the specified parameter can accept signed number values; false
otherwise.
Authorization
Scripts that use this method require authorization with one or more of the following scopes :
-
https://www.googleapis.com/auth/script.external_request