1. Launch the SQL Enterprise Manager
2. Expand the appropriate server and then expand the Databases folder.
3. Click the database you want to create scripts for and choose "Generate SQL Scripts..." in the Object menu.
In that dialog you can select the tables, and all the types of scripts you can create. Use the help button to get info on all of the options.
HTH
>Forgive my ignorance. How can I get create the scripts and then how do I execute them? Is that detailed in the SQL docs?
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams
