Check if table exists in SQL Server
Check if table exists in SQL Server
Check if table exists in SQL Server
Re: Check if table exists in SQL Server
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.
To check if a table exists use:
```
IF (EXISTS (SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'TheSchema'
AND TABLE_NAME = 'TheTable'))
BEGIN
--Do Stuff
END
```
To check if a table exists use:
```
IF (EXISTS (SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'TheSchema'
AND TABLE_NAME = 'TheTable'))
BEGIN
--Do Stuff
END
```