How do I force an update of Information_schema.columns?
Posted on 2007-08-08
First thank you for your time.
My INFORMATION_SCHEMA.COLUMNS appears to need updating.
I have an Sql Server 2005 database with about 30 tables in it. One of the tables is called 'Contacts' and it has 25 columns.
When I execute the following queries from within Sql Server Management Studio, I get the following results:
Query 1) select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME= 'Contacts'
Returns) An empty recordset.
Query 2) select count(*) from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME= 'Contacts'
Query 3) select distinct TABLE_NAME from INFORMATION_SCHEMA.COLUMNS
Returns) MSreplication_options, spt_fallback_db, spt_fallback_dev, spt_fallback_usg, spt_monitor, spt_values. And that's it! My tables are not listed in the INFORMATION_SCHEMA.COLUMNS table!
What did I do wrong? Where's my data? Is there a way to force an update of the INFORMATION_XXX tables?