Microsoft KB Archive/268243

= PRB: Column SS_DATA_TYPE From sp_columns is The Same As syscolumns.type And Not syscolumns.xtype =

Article ID: 268243

Article Last Modified on 10/27/2000

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q268243



SYMPTOMS
There is a discrepancy between the values shown by the column ss_data_type in the sp_columns stored procedure and the value shown by the xtype column in the syscolumns system table. The column ss_data_type is actually the same as the type column in the syscolumns table.



WORKAROUND
Use syscolumns.type, which is the same as the sp_columns.ss_data_type, instead of syscolumns.xtype.



MORE INFORMATION
Microsoft does not recommend that you query the system tables directly. However, you can use INFORMATION_SCHEMA views instead.