Easiest thing to do is just do a "Replace All" of "OldTable" with "MyNewTable" in the script.
~~Bonnie
>Many thanks for reply.
>Yes, I only changed Table Name.
>I thought that this was the only thing that needs to be changed
>I was getting messages to the effec that the name was already used
>Regards,
>Gerard
>
>>
>>Did you change only table name?
>>
>>You must change name of indexes, primary key, foreign keys, default values, checks.
>>
>>MartinaJ
>>
>>>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