Checking if table exists or not in SQL Azure

Question

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

Are you asking this - stackoverflow.com/questions/8915521/… — PinnyM
– PinnyM, Commented Jan 25, 2012 at 16:54

Devart · Accepted Answer · 2012-01-25 16:55:29Z

8

Use this query -

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.

answered Jan 25, 2012 at 16:55

Devart

120k23 gold badges172 silver badges189 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1