Re: How to rename a table in a database?

Hello Mark,
Thanks for the information and the support. I will look into that interface.

So that the best generic method will be to copy the table. This particular
table may change with each version of our software as we add more features
and trying to maintain such backward compatibilty is a big pain, especially
since the database provider is not fixed - it might be Oracle, Access, SQL
Server. Many will not buy into XML replacements :((

Thanks to you all for the information.

Best regards,
Paul.



>From: Mark Dawson <[email protected]>
>Reply-To: OLEDB_DEV <[email protected]>
>To: [email protected]
>Subject: Re: [OLEDB_DEV] How to rename a table in a database?
>Date: Thu, 17 Apr 2003 15:06:56 +0100
>
>Paul,
>
>I think that Jet supports the IAlterTable interface which allows a table
>to be renamed or columns added etc.  I don't know of any other provider
>that supports it though if you are looking for a generic solution.
>
>Mark
>--------------------------------------------------------------
>Mark Dawson ([email protected])
>Software Project Leader
>SRH Systems Ltd.
>Lowesmoor Wharf, Worcester.
>WR1 2RS. UK
>+44 (0)1905 613361
>
>
>-----Original Message-----
>From: Paul Selormey [mailto:[email protected]]
>Sent: 17 April 2003 14:59
>To: [email protected]
>Subject: Re: [OLEDB_DEV] How to rename a table in a database?
>
>
>Hello Kim and Dumitru,
>Thanks for the information and the support. Anyway to get something
>similar
>in MS Access?
>
>Best regards,
>Paul.
>
>
>
> >From: Paul Selormey <[email protected]>
> >Reply-To: OLEDB_DEV <[email protected]>
> >To: [email protected]
> >Subject: [OLEDB_DEV] How to rename a table in a database?
> >Date: Thu, 17 Apr 2003 06:08:53 +0000
> >
> >Hello All,
> >
> >Is there a way by SQL statement, if any, to rename a table in a
>database?
> >Or there any vendor specific way of doing it?
> >
> >Best regards,
> >Paul.
> >
> >
> >_________________________________________________________________
> >MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
> >http://join.msn.com/?page=features/virus
> >
> >You can read messages from the OLEDB_DEV archive, unsubscribe from
> >OLEDB_DEV,
> >or subscribe to other DevelopMentor lists at
>http://discuss.develop.com.
>
>
>_________________________________________________________________
>Tired of spam? Get advanced junk mail protection with MSN 8.
>http://join.msn.com/?page=features/junkmail
>
>You can read messages from the OLEDB_DEV archive, unsubscribe from
>OLEDB_DEV,
>or subscribe to other DevelopMentor lists at http://discuss.develop.com.
>
>________________________________________________________________________
>This email has been scanned for all viruses by the MessageLabs SkyScan
>service. For more information on a proactive anti-virus service working
>around the clock, around the globe, visit http://www.messagelabs.com
>________________________________________________________________________
>
>________________________________________________________________________
>This email has been scanned for all viruses by the MessageLabs SkyScan
>service. For more information on a proactive anti-virus service working
>around the clock, around the globe, visit http://www.messagelabs.com
>________________________________________________________________________
>
>You can read messages from the OLEDB_DEV archive, unsubscribe from
>OLEDB_DEV,
>or subscribe to other DevelopMentor lists at http://discuss.develop.com.


_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

You can read messages from the OLEDB_DEV archive, unsubscribe from OLEDB_DEV,
or subscribe to other DevelopMentor lists at http://discuss.develop.com.