General information
Category:
Coding, syntax and commands
Hi Bonnie. Thanks fore your reply.
The Table I am trying to copy is just a 'History' Table, so I want to keep the Field Names the same
I prefix all my Field name with the Table Name e.g. Table is INV and Field is INV_CUSNUM
My History Table would be HIS , but I want to keep all the names as INV_CUSNUM etc
Regards,
Gerard
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only