I use the "select * into" option that others have mentioned. But I also generate a script with all indexes and constraints. The "select * into" does...

Thanks for the help. I will use your suggestions.