|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
| ms.sqlserver.setup Questions about SQL Server. |
 |
|
|
LinkBack | Outils de la discussion |
28/07/2007, 22h28
|
#1 |
Messages: n/a
Hébergeur: |
how to make a duplicate of a table?
Hi,
is it possible to make a duplicate of a table (with another name of course) with a command like 'copy' or 'duplicate' or ...? Thanks Chris |
|
|
28/07/2007, 23h33
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: how to make a duplicate of a table?
You can use SELECT INTO:
SELECT * INTO AnotherTable FROM MyTable However, this will not copy the constraints and indexes. -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau "Chris" <gddfd@er.df> wrote in message news:%23k6PN5V0HHA.3800@TK2MSFTNGP06.phx.gbl... Hi, is it possible to make a duplicate of a table (with another name of course) with a command like 'copy' or 'duplicate' or ...? Thanks Chris |
|
|
|
30/07/2007, 23h09
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: how to make a duplicate of a table?
Thanks
"Tom Moreau" <tom@dont.spam.me.cips.ca> schreef in bericht news:eBhNTdW0HHA.1204@TK2MSFTNGP03.phx.gbl... > You can use SELECT INTO: > > SELECT > * > INTO > AnotherTable > FROM > MyTable > > However, this will not copy the constraints and indexes. > > -- > Tom > > ---------------------------------------------------- > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS > SQL Server MVP > Toronto, ON Canada > https://mvp.support.microsoft.com/profile/Tom.Moreau > > > "Chris" <gddfd@er.df> wrote in message > news:%23k6PN5V0HHA.3800@TK2MSFTNGP06.phx.gbl... > Hi, > > is it possible to make a duplicate of a table (with another name of > course) > with a command like 'copy' or 'duplicate' or ...? > Thanks > Chris > > |
|
|
|
| Outils de la discussion | |
|
|
