INFORMATION_SCHEMA « System « SQL Server / T-SQL






1.INFORMATION_SCHEMA.TABLES
2.Query INFORMATION_SCHEMA.VIEWS
3.Another way to test for the existence of a table