How to create a new table

How can I create a new table by copying registers from another table?
i'm getting mad traying it.
Jordi,
I don't know if I understand what you are trying. Would it be:
SELECT * INTO NewTable FROM OldTable
Alternatively, if you are trying to create a duplicate of a table more
formally, you could use Query Analyzer's object browser and create a "create
table script" from the old table. Edit that script to replace Oldname with
Newname run the script. You should get an exact duplicate. (With no data in
it yet.)
Russell Fields
"Jordi de Reus" <anonymous@.discussions.microsoft.com> wrote in message
news:29B2600C-0853-4B5A-A97A-CB6FE89E7E2A@.microsoft.com...
> How can I create a new table by copying registers from another table?
> i'm getting mad traying it.

How to create a new table

How can I create a new table by copying registers from another table?
i'm getting mad traying it.Jordi,
I don't know if I understand what you are trying. Would it be:
SELECT * INTO NewTable FROM OldTable
Alternatively, if you are trying to create a duplicate of a table more
formally, you could use Query Analyzer's object browser and create a "create
table script" from the old table. Edit that script to replace Oldname with
Newname run the script. You should get an exact duplicate. (With no data in
it yet.)
Russell Fields
"Jordi de Reus" <anonymous@.discussions.microsoft.com> wrote in message
news:29B2600C-0853-4B5A-A97A-CB6FE89E7E2A@.microsoft.com...
> How can I create a new table by copying registers from another table?
> i'm getting mad traying it.