Open Enterprise Manager.
Drill down to the desired database.
Drill down to tables.
On the right side of the screen where all the tables are, right click the mouse.
Select "ALL TASKS"
Select "Generate SQL Script..."
Follow your nose from there...