How to rename columnnames in a table in .NET

20 Apr 2006 7:29 PM

Jayashri Yadav

Hi,

I would like to know if there is any way to rename a column in a table in
access database using .Net programmatically.

Thank you

--
Jayashri

21 Apr 2006 7:44 AM

Cor Ligthert [MVP]

Jayashri,

AFAIK you can use the SQL Alter Table, how far it is supported in Access is
something I don't know, however I assume it would go.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_aa-az_3ied.asp

I hope this helps,

Cor

Show quote

"Jayashri Yadav" <JayashriYa***@discussions.microsoft.com> schreef in
bericht news:F809DB8C-64F6-44A9-86D0-CEC29726CAA0@microsoft.com...
> Hi,
>
> I would like to know if there is any way to rename a column in a table in
> access database using .Net programmatically.
>
> Thank you
>
> --
> Jayashri

27 Apr 2006 12:23 AM

clintonG

Its done using ADOX (as I've done using ASP) but I don't know how to use
ADOX via ADO/ASP.NET yet. I do know ADOX is documented at MSDN and more can
be found by searching the web.

--
<%= Clinton Gallagher
NET csgallagher AT metromilwaukee.com
URL http://clintongallagher.metromilwaukee.com/

Show quote

"Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message
news:e218lcRZGHA.4580@TK2MSFTNGP03.phx.gbl...
> Jayashri,
>
> AFAIK you can use the SQL Alter Table, how far it is supported in Access
> is something I don't know, however I assume it would go.
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_aa-az_3ied.asp
>
> I hope this helps,
>
> Cor
>
> "Jayashri Yadav" <JayashriYa***@discussions.microsoft.com> schreef in
> bericht news:F809DB8C-64F6-44A9-86D0-CEC29726CAA0@microsoft.com...
>> Hi,
>>
>> I would like to know if there is any way to rename a column in a table in
>> access database using .Net programmatically.
>>
>> Thank you
>>
>> --
>> Jayashri
>
>