Re: Reloading a table

Bear in mind that if you drop the table, you will lose any triggers that go with it. Creating a table as select * will not duplictae any triggers.

"Scott Mattes" <Scott_at_TheMattesFamily.ws> wrote in message news:bh1Ea.1051$Jw6.761174_at_news1.news.adelphia.net...
> Also, depending on what you are trying to accomplish, you could
>
> create table my_table_backup as select * from my_table;
>
>
> The do either
>
> delete my_table;
>
> insert into my_table select * from my_table_backup;
>
> OR
>
> drop table my_table;
>
> create table my_table as select * from my_table_backup;
>
>
>
> "Michael Kelly" <miteke_at_yahoo.com> wrote in message
> news:11f0f8fa.0306051144.9b772bf_at_posting.google.com...
> > I wish to create a .sql file I can run to reload a table. Is there a
> > simple way to dump the contents of a table into an sql format file? In
> > other words a series of insert statements.
> >
> > please respond to miteke_at_yahoo.com
>
>
Received on Mon Jun 09 2003 - 11:53:31 CEST