Re: How to rename a table in a database?

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.