>CREATE DATABASE Test >GO >USE Test >GO >CREATE TABLE Tbl1 (Fld1 int) >CREATE TABLE Tbl2 (Fld1 int) >CREATE TABLE Tbl3 (Fld1 int) >GO >sp_MsForEachTable 'DROP TABLE ?' >>Maybe you sholud try it with EXEC:
>EXEC sp_MsForEachTable 'DROP TABLE ?' >This doesn't work for me. I always have the error saying that the stored procedure is not found.