[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • Last Modified:

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?
0
mathematics
Asked:
mathematics
1 Solution
 
bequetteCommented:
You can select from the sysobjects table try this
if exists(select * from sysobjects where name="MY_TABLE_NAME")

0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now