Edit

Share via

getTypeInfo Method (SQLServerDatabaseMetaData)

  • Article

Download JDBC driver

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

Syntax

  
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 (9.x) (or later) 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

SQLServerDatabaseMetaData Methods
SQLServerDatabaseMetaData Members
SQLServerDatabaseMetaData Class