This post originated from an RSS feed registered with .NET Buzz by Jeff Key. Original Post: Determining if a table exists Feed Title: Jeff Key Feed URL: http://www.asp.net/err404.htm?aspxerrorpath=/jkey/Rss.aspx Feed Description: Topics revolve around .NET and the Windows platform. Latest .NET Buzz Posts Latest .NET Buzz Posts by Jeff Key Latest Posts From Jeff Key

Quiz

How do you determine if a table exists in SQL Server?

a)  sysobjects
b)  information_schema.tables
c)  other

If my crack research team is to be trusted, the answer is “B”.  They claim the reason is that the sysobjects table's schema may change over time but the information_schema.tables view will not.