How to check if table exists or not in ms sql server database

In this programming tutorial you will learn how to check if table exists or not in ms sql server database. Doing so is quite easy in ms sql server. sp_help command is use for this purpose. So let's have a look over it.
How to check if table exists or not in ms sql server database
sp_help yourtblname
Yeah that's it. If table exists then this command will give you the structure of your table else it will will give you the following error

The object 'blah blah' does not exist in database 'blah blah' or is invalid for this operation.

I love your feedback.

0 comments: