HI.
I want to create a new Table in a SQLServer database, with exactly the sam structure as an exisitng Table (i.e. Same Field names, same Indexes, Same defaults)

I tried this in SSMS and scripted the Existing Table, then chnged the name in the script (Create table MyNewTable) and executed it, but it is still giving errors. I have Defaults set on a lot of the fields and I also have indexes set up.

Is there any easy way to do this , rather than having to set up from scratch , as there are about 150 fields

Tia
Gerard