<t>For queries like this it is always best to use an INFORMATION_SCHEMA view. These views are (mostly) standard across many different databases and rarely change from version to version.<br/>
<br/>
To check if a table exists use:<br/>
<br/>
IF (EXISTS (SELECT * <br/>
FROM INFORMATION_SCHEMA.TABLES <br/>
WHERE TABLE_SCHEMA = 'TheSchema' <br/>
AND TABLE_NAME = 'TheTable'))<br/>
BEGIN<br/>
--Do Stuff<br/>
END<br/>
<br/>
```</t>
