Simple question, simple answer
SQL Query to return the data
SELECT TABLE_NAME FROM DBName.INFORMATION_SCHEMA.Tables WHERE TABLE_NAME='Article'
How do I check this in C#?
As for how you check that in C#? You just make sure the Row count returned from the query is 1. See this article I have already posted.
How do I get the number of rows returned from a Microsoft SQL Query in C#?
Return to ADO.NET and Database with C#