I am getting different results for two queries about a table column.
when I run the following query against syscolumns:
Select so.name,so.xtype ,sc.name,sc.xtype from sysobjects so
Join syscolumns sc on sc.id = so.id
Where so.name = 'abn_'
And sc.name = 'person_id'
I get no rows
when I run
select * from information_schema.columns
where table_name = 'abn_'
and column_name = 'person_id'
I get the row for abn_.person_id
Do I have a corrupt database? And how can I fix it?