Re: rename table with vb code

rename a to b;

this is also a probable solution. could pass a and b as arugments to a procedure call in the database and coudl execute this stmt in the procedure.

Thorsten Hoefer wrote:

> create tabe a as select * from b;
> drop table b;
>
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> schrieb im
> Newsbeitrag news:3c7a180f$0$232$ed9e5944_at_reading.news.pipex.net...
> > you can do this using a sp in Oracle moreover you could pass the table
> name
> > as a parameter name to the procedure. However almost certainly you don't
> > want to. what is the underlying reason for creating the table using an SP
> in
> > the first place?
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > *****************************************
> > Please include version and platform
> > and SQL where applicable
> > It makes life easier and increases the
> > likelihood of a good answer
> >
> > ******************************************
> > "Dave K" <randave_at_optonline.net> wrote in message
> > news:e7Od8.37402$co1.6824229_at_news02.optonline.net...
> > > I use VB with ADO 2.5 to connect to a database that could be Access
> 2000,
> > > SQL Server, or Oracle. A stored procedure creates a table, and then I
> > need
> > > to change the name of that table.
> > >
> > > Is there a good way to do this in code, or can I do this with a
> > query/stored
> > > procedure for each database?
> > >
> > > Thanks!
> > >
> > > - Dave
> > >
> > >
> >
> >

--

Atul Agrawal                     | Atul Agrawal
Masters Student, CS Deptt.       | 3501, St Paul Street,
Johns Hopkins University         | Apt # 1018,
3400, N Charles Street, NEB 224  | Baltimore,
Baltimore, MD 21218.             | MD 21218.
                                 |
Hello: 410-516-8291 (Lab)        | Hello: 410-366-6852 (Resi)