How could I permanently delete a SQL table during a Store Procedur

[Guest]

I tried with "Delete tblName" but didnt work.

Thanks for any suggestions.

 

[Al Reid]

I tried with "Delete tblName" but didnt work.

Thanks for any suggestions.

Did you try "DROP TABLE tblName"?

 

[Cor Ligthert [MVP]]

Eduardo,

Have a look at "Drop"

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_de-dz_7uud.asp

What it has to do with a SP is something that at least I don't understand,
so maybe can you declare that more.

I hope this helps so far.

Cor