EXPRTYPE function [Miscellaneous]

EXPRTYPE( string-expression, integer-expression )

string-expression A SELECT statement. The expression whose data type is to be queried must appear in the SELECT list. If the string is not a valid SELECT statement, NULL is returned.
integer-expression The position in the SELECT list of the desired expression. The first item in the SELECT list is numbered 1. If the integer-expression value does not correspond to a SELECT list item, NULL is returned.

LONG VARCHAR

For user-defined domains, EXPRTYPE returns the description of the underlying data type, not the domain name. For example, suppose you create a domain, mydomain, and define a table column using mydomain, as follows:

CREATE DOMAIN mydomain CHAR(20);
CREATE TABLE mytable( colA mydomain, colB DATETIME );

When you execute SELECT EXPRTYPE( 'SELECT * FROM mytable', 1 ), the data type returned is char(20), not mydomain.

SQL/2008 Vendor extension.

The following statement returns smallint when executed against the SQL Anywhere sample database:

SELECT EXPRTYPE( 'SELECT LineID FROM SalesOrderItems', 1 );

EXPRTYPE function [Miscellaneous]

Syntax

Parameters

Returns

Remarks

See also

Standards and compatibility

Example