<div>
IF OBJECT_ID ('AdventureWorks.dbo.AWBui<wbr />ldVersion'<wbr />,'U') IS NOT NULL<br />
Print 'Table Exists'<br />
ELSE<br />
Print 'Table Does Not Exists'<br />
<br />
where 'AdventureWorks.dbo.AWBuil<wbr />dVersion' is the object name and 'U' is the object type which represents a table<br />
<br />
<a href="http://www.sqlservercurry.com/2007/12/check-if-database-or-table-exists-using.html" rel="ugc">http://www.sqlservercurry.com/2007/12/check-if-database-or-table-exists-using.html</a><br />

</div>


IF OBJECT_ID ('AdventureWorks.dbo.AWBuildVersion','U') IS NOT NULL
Print 'Table Exists'
ELSE
Print 'Table Does Not Exists'

where 'AdventureWorks.dbo.AWBuildVersion' is the object name and 'U' is the object type which represents a table

http://www.sqlservercurry.com/2007/12/check-if-database-or-table-exists-using.html [http://www.sqlservercurry.com/2007/12/check-if-database-or-table-exists-using.html]


<div>
<div class="content wysiwyg-content">
I need a query that will check to see if a table ( PaymentType ) exist in a database. &nbsp;If it does exist the query needs to return a 1 if the table does not exist return a 0.<br />
<br />
Any help in creating this query will be appreciated.<br />

</div>
</div>


I need a query that will check to see if a table ( PaymentType ) exist in a database.  If it does exist the query needs to return a 1 if the table does not exist return a 0.

Any help in creating this query will be appreciated.


Does A Table Exist In A Database

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.