Checking if table exists or not in SQL Azure

Question

Could anyone help me in checking whether table exists or not in sql azure?

Answer 1

Use this query -

Click to copy

SELECT
  *
FROM
  sys.tables t
JOIN
  sys.schemas s
    ON t.schema_id = s.schema_id
WHERE
  s.name = 'dbo' AND t.name = 'table1'

...specify your schema and table name.