Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server stored procedure
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL Server stored procedure
Miscellaneous
Thread ID:
00363595
Message ID:
00363595
Views:
34
I need to check the existence of a table in SQL

something like:

IF exists ('mytable')
DROP TABLE mytable

I can't get the right sintax to make it work in a SQL stored procedure.

can anybody help me ?

thanks
____________________________
Luis Perez
Millennium Data Solutions, Corp.
President & CEO
e-mail: luis@mds-corp.com
http://www.mds-corp.com
USA
____________________________
Next
Reply
Map
View

Click here to load this message in the networking platform