Renaime a Data file with and sql statement

Hi want to rename a data filed  with a sql statement, i,m using vb 6

i know the alter statement but don't know if there any function to renaime a data filed.
LVL 1
cano63Asked:
Who is Participating?
 
game-masterConnect With a Mentor Commented:

good morning!

i hope this give u idea..

ALTER TABLE <your table name> RENAME COLUMN <field to rename> TO <new fieldname>


game-master
0
 
Ryan ChongCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.