How do i create a script file for my sql7 database that when run recreates my database tables and fields???

any ideas?????????????????