Hi Naomi. Tbks for replying.
I was only chaging the Table Name, so Indexes at least would then not have had a Unique name across the database
regards,
Gerard


>>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
>
>Constraints and indexes must be unique in the database.