rename a column

V

vds_sandeep

New member
Local time
Today, 05:24
Joined
Jan 25, 2007
Messages
4
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..
 
vds_sandeep said:
as soon as possible
Click to expand...
not very demanding are you:rolleyes:

rename the column using table properties.

Col
 
I'm on my way VDS, to hand it to you personally.
 
Dennisk said:
I'm on my way VDS, to hand it to you personally.
Click to expand...

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

Brian
 
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.
 
You must log in or register to reply here.

Similar threads

P
rename file
Replies
2
Views
211
theDBguy
theDBguy
southwestgooner
Help!!! Update Query to update fields in table???
Replies
2
Views
221
Pat Hartman
P
H
Long Text Type field not shows in list box
Replies
5
Views
189
gemma-the-husky
gemma-the-husky
N
Group BY or ORDER BY in a UNION SELECT Query
Replies
4
Views
161
Pat Hartman
P
H
Solved Query with multiple criteria
Replies
6
Views
479
Pat Hartman
P

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom