getTypeInfo Method (SQLServerDatabaseMetaData)

  • Article

Retrieves a description of all the standard SQL types that are supported by the current database.

public java.sql.ResultSet getTypeInfo()

Return Value

A SQLServerResultSet object.

Exceptions

SQLServerException

Remarks

This getTypeInfo method is specified by the getTypeInfo method in the java.sql.DatabaseMetaData interface.

The result set returned by the getTypeInfo method will contain the following information:

Name Type Description

TYPE_NAME

String

The name of the data type.

DATA_TYPE

short

The SQL data type from java.sql.Types.

PRECISION

int

The total number of significant digits.

LITERAL_PREFIX

String

The character or characters used before a constant.

LITERAL_SUFFIX

String

The character or characters used to terminate a constant.

CREATE_PARAMS

String

The description of the creation parameters for the data type.

NULLABLE

short

Indicates if the column can contain a null value. It can be one of the following values:

typeNoNulls (0)

typeNullable (1)

typeNullableUnknown (2)

CASE_SENSITIVE

boolean

Indicates if the data type is case sensitive. "true" if the type is case sensitive; otherwise, "false".

SEARCHABLE

short

Indicates if the column can be used in a SQL WHERE clause. It can be one of the following values:

typePredNone (0)

typePredChar (1)

typePredBasic (2)

typeSeachable (3)

UNSIGNED_ATTRIBUTE

boolean

Indicates the sign of the data type. "true" if the type is unsigned; otherwise, "false".

FIXED_PREC_SCALE

boolean

Indicates that the data type can be a money value. "true" if the data type is money type; otherwise, "false".

AUTO_INCREMENT

boolean

Indicates that the data type can be automatically incremented. "true" if the type can be auto incremented; otherwise, "false".

LOCAL_TYPE_NAME

String

The localized name of the data type.

MINIMUM_SCALE

short

The maximum number of digits to the right of the decimal point.

MAXIMUM_SCALE

short

The minimum number of digits to the right of the decimal point.

SQL_DATA_TYPE

int

Not supported by the JDBC driver.

SQL_DATETIME_SUB

int

Not supported by the JDBC driver.

NUM_PREC_RADIX

int

The number of bits or digits for calculating the maximum number that a column can hold.

INTERVAL_PRECISION

smallint

The value of interval leading precision.

USERTYPE

smallint

The usertype value from the systypes table. For more information, see SQL Server Books Online.

Note

For more information about the data returned by the getTypeInfo method, see "sp_datatype_info (Transact-SQL)" in SQL Server Books Online.

Example

The following example demonstrates how to use the getTypeInfo method to return information about the data types used in a SQL Server 2005 database.

public static void executeGetTypeInfo(Connection con) {
   try {
      DatabaseMetaData dbmd = con.getMetaData();
      ResultSet rs = dbmd.getTypeInfo();
      ResultSetMetaData rsmd = rs.getMetaData();

      // Display the result set data.
      int cols = rsmd.getColumnCount();
      while(rs.next()) {
         for (int i = 1; i <= cols; i++) {
            System.out.println(rs.getString(i));
         }
      }
      rs.close();
   } 

   catch (Exception e) {
      e.printStackTrace();
   }
}

See Also

Reference

SQLServerDatabaseMetaData Class

Concepts

SQLServerDatabaseMetaData Methods
SQLServerDatabaseMetaData Members