• In management studio, right click on the database and go to tasks, generate scripts. Select the tables you want to script and thats about it. You get options to add keys/indexes etc as you go through.