Can we know a table exist?

When we create a table,we must know if it is exist.
When we drop a table,we must know if it is exist.
So how to know?
mathematicsAsked:
Who is Participating?
 
bequetteConnect With a Mentor Commented:
You can select from the sysobjects table try this
if exists(select * from sysobjects where name="MY_TABLE_NAME")

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.