Re: ALTER TABLE: drop all objects and recreate them.
From: Costi Stan (stancosti_at_yahoo.com)
Date: 10/20/04
- Next message: Louis Davidson: "Re: Same transaction on 2 different DB"
- Previous message: Chandler Chao: "Maximum length of VARCHAR"
- In reply to: Anith Sen: "Re: ALTER TABLE: drop all objects and recreate them."
- Next in thread: Anith Sen: "Re: ALTER TABLE: drop all objects and recreate them."
- Reply: Anith Sen: "Re: ALTER TABLE: drop all objects and recreate them."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 20 Oct 2004 19:18:04 +0300
With <Generate Scripts> from Enterprise Manager you'll get Drop Table and
Create Table. This way all the values are lost.
"Anith Sen" <anith@bizdatasolutions.com> wrote in message
news:%23mGqr5rtEHA.2804@TK2MSFTNGP14.phx.gbl...
> Have you looked in to the Enterprise Manager option "Generate Scripts" ?
>
> --
> Anith
>
- Next message: Louis Davidson: "Re: Same transaction on 2 different DB"
- Previous message: Chandler Chao: "Maximum length of VARCHAR"
- In reply to: Anith Sen: "Re: ALTER TABLE: drop all objects and recreate them."
- Next in thread: Anith Sen: "Re: ALTER TABLE: drop all objects and recreate them."
- Reply: Anith Sen: "Re: ALTER TABLE: drop all objects and recreate them."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
