Message
From
03/06/2008 13:27:02
To
Todo
General information
Fórum:
Microsoft SQL Server
Category:
SQL syntax
Título:
Re-create the table, but preserve the data
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
ID da thread:
01321355
ID da mensagem:
01321355
Views:
71
Hi everybody,
I want to have a create table script which I can execute multiple times (so I would need to have drop statements first).
I also would like to be able to preserve existing data.
Is there a way to write such a script?
Thanks a lot in advance.
I want to have a create table script which I can execute multiple times (so I would need to have drop statements first).
I also would like to be able to preserve existing data.
Is there a way to write such a script?
Thanks a lot in advance.