change the name of the fieldname

Expand Post »

I have a button and on the click of that button i want to change a the name of few fielnames of Ms access table In Vb.net coding.

Similar Threads

most urgent in Visual Basic 4 / 5 / 6
How to use fieldname in 'if' condition ? in VB.NET
Changing a datagridview's combobox items based on another combobox in C#
Will the jsp code will change if we connected to the oracle database ? in JSP
can i use mysql database with asp in ASP

kritiohri

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

24 posts
since Nov 2008

Permalink

Dec 26th, 2008

Re: change the name of the fieldname

There's no RENAME in SQL. AFAIK the only way to rename field name in Access table is to first DROP field then add field (ALTER). With SQL Server you can rename fields with a stored procedure.

So the options left are:
1) change the field name manually
2) leave the field name as it is and when you read (SELECT) from the table use an alias for the field name

Teme64

Reputation Points: 218

Solved Threads: 201

Veteran Poster

Offline

1,024 posts
since Aug 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: help with this code

Next Thread in VB.NET Forum Timeline: problem in dropdownlist

DaniWeb Message

Cancel Changes

User Name
Password