Microsoft KB Archive/270896

= INFO: SQL Server CE Query Analyzer Does Not Display Descriptive Data Type =

Article ID: 270896

Article Last Modified on 2/22/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Windows CE Edition

-



This article was previously published under Q270896



SUMMARY
When you use the Microsoft SQL Server CE Query Analyzer tool to connect to a SQL Server CE database and you run the following query, the data types are represented by numbers instead of by a description: SELECT data_type FROM INFORMATION_SCHEMA.COLUMNS



MORE INFORMATION
The Microsoft SQL Server CE Books Online only documents descriptive SQL Server CE data types, not OLEDB data types or codes. You can use the following table to determine the data types:

Keywords: kbcodesnippet kbinfo KB270896

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.