rename a column

[vds_sandeep]

Hi,

i want to rename a column name "id to concept_id" through sql query
please send me the query.

as soon as possible

thanks in advance..

 

[KenHigg]

You're kidding - right?

 

[ColinEssex]

as soon as possible

not very demanding are you

rename the column using table properties.

Col

 

[neileg]

This thread may help you understand.
http://www.access-programmers.co.uk/forums/showthread.php?t=122354

 

[Dennisk]

I'm on my way VDS, to hand it to you personally.

 

[Brianwarnock]

I'm on my way VDS, to hand it to you personally.

LOL, but surely you will type it in for him not just hand him hard copy.

Brian

 

[Moniker]

Dennis, make sure you wipe your feet before going in, and remember, he likes tangerine lip gloss for when you plant one on his butt.

I'm thinking perhaps if this guy can find the keywords to alter his table, he may figure out that he can't rename a column through SQL, but he can change the data definition by adding a column with the column name he wants, copying his original column's data to the new column, and then he could drop his original column from the table that was altered.

Just a thought.

Oh, and Dennis, remember he likes seedless grapes while being fanned with feathers.

 

[rhett7660]

WOW............. speachless...