adox rename table?

adox rename table?

Post by Phil Chetcut » Fri, 18 Aug 2000 04:00:00



According to the msdn adox tables name property is read only for any tables
that have been appended to the collection (catalog).

Anyone got any ideas on how to do a table rename?

Direct email greatly appreciated.

--
Phil Chetcuti

 
 
 

adox rename table?

Post by William Ed Carde » Fri, 18 Aug 2000 04:00:00


If you are using SQL Server you can run the stored procedure sp_renamedb to
rename a database.  Not sure of any way in ADO to do the same.

Ed


> According to the msdn adox tables name property is read only for any tables
> that have been appended to the collection (catalog).

> Anyone got any ideas on how to do a table rename?

> Direct email greatly appreciated.

> --
> Phil Chetcuti