· 8 years ago · Apr 04, 2018, 06:16 PM
1IF (NOT EXISTS (SELECT *
2 FROM INFORMATION_SCHEMA.TABLES
3 WHERE TABLE_SCHEMA = 'TheSchema'
4 AND TABLE_NAME = 'TheTable'))
5BEGIN
6 CREATE TABLE yourtable ...
7END