>sp_MsForEachTable is hidden SP stored in master DB.
>
>This works for me :
>

>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.

I have tried your code as is. The exact message is:

Msg 2812, Level 16, State 62, Line 1
Cound not find stored procedure 'sp_MsForEachTable'.