ÃÂ I'm trying to obtain the metadata for a SqlServer CE database. As Stored procedures are not supported I do not have the 'sp_columns' system stored procedure available with Sql Server 2005/2008 etc. Hence I'm querying the INFORMATION_SCHEMA views.
The 'sp_columns' returned a DATA_TYPE column desscribed as -
Integer code for ODBC data type. If this is a data type that cannot be mapped to an ODBC type, it is NULL. The native data type name is returned in the TYPE_NAME column.
How can I obtain this value for a SqlServer CE column?
View Complete Post