[AccessD] Renaming a field through code

I don't know if you can do it in code or not but I did find an old pass thru query that was supposed to rename a field in an SQL server table. It was in a test DB so cannot recall if it worked or not but anyway here it is.

EXEC sp_rename 'dbo_SurfaceMaster.UWI', 'API10', 'COLUMN';

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software
Sent: Friday, July 18, 2008 11:56 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Renaming a field through code

Dear List:

Is is possible to rename a field in a linked table through code?

MTIA





Rocky Smolin

Beach Access Software

858-259-4334

www.e-z-mrp.com <http://www.e-z-mrp.com/>

www.bchacc.com <http://www.bchacc.com/>






--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com