Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
SQL Server stored procedure
Divers
Thread ID:
00363595
Message ID:
00363595
Vues:
35
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 ____________________________