I have an Access database and wish to change the name of a table column from within an ASP.NET application.

I would prefer to use an SQL statment and an OleDbCommand to do this and then ExecuteNonQuery() etc.

Two possible SQL statements are:

or
Neither of these statements work and I get an SQL Syntax Error.

Does anyone know what the correct SQL statment is? I can add and remove columns OK using similar SQL statements, just can't rename a column/field!

Cheers

Graham Wilson

EXEC sp_rename
    @objname = 'table_name.old_column_name',
    @newname = 'new_column_name',
    @objtype = 'COLUMN'

1. The post is 2 Years old.
2. sp_rename will work in SQL Server, not in access.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Professional Search Engine Optimization with ASP.NET

Professional IIS 7 and ASP.NET Integrated Programming

================================================== =========

YOUR post is 2 years old. nanny Nanny PooPoo!!

to rename

for eg chenge column name for fnmae to fname in table employee

step 1 rename employee to employe
step 2 create table employee (fname,lname , and other columns of table) as select * from employe.

then drop employe
and add constraints againn to employee if any exist.

alter table do not change name of column , table and size of column if table data exist

I feel obligated to revive this thread, as part of a bi-annual tradition started in September of 2005. This thread was then bumped in September 2007, September 2009, and May 2011. From September 2013, I look forward to the response from a tradition-loving soul in September 2015.

Long live sp_rename!

Happy 10 years to this thread! And once again, a 2 year gap between posts! And once again, long live sp_rename!

Happy 12th! Seeya in another two years!