Are these temporary tables? If not, just construct the command that you're interested in and use EXECUTE() to execute it. Just one thing to watch: since this is dynamic SQL, the user calling the proc must have permission CREATE TABLE permission.
-Mike