This is a discussion on "rename column name" within the Databases section. This forum, and the thread "rename column name are both part of the Program Your Website category.
|
|
|
|
|
 |
||
rename column name
|
||
| Notices |
 |
|
|
LinkBack | Thread Tools |
|
#1
Nov 10th, 2005, 18:10
|
|||
|
|||
|
rename column name
I'm having trouble updating a database column name. What's wrong with this:
sql="ALTER TABLE products RENAME COLUMN product_id to prod_id" objconn.execute(sql) I'm using classic ASP with an access database. Is it not possible to update column names with access databases? I get an error message saying that there is a syntax error in the sql.        
|
|
|
|
#2
Nov 10th, 2005, 19:14
|
||||
|
||||
|
Re: rename column name
This *may* work
__________________
Click the 'Thanks!' button if this post has helped you Rob - Webforumz Founder
Last Blog Entry: Creative Labs threaten developer over home made drivers.... (Apr 1st, 2008)
|
|
#3
Nov 11th, 2005, 00:08
|
||||
|
||||
|
Re: rename column name
Don't know about Access, in MS SQL Server you would use a system stored procedure.
Here is a link that seems relevant.... http://forums.microsoft.com/MSDN/Sho...25996&SiteID=1
|
|
| Tags |
| rename, column, name |
| Thread Tools | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Clone Select - Rename not working in IE | Awok | JavaScript Forum | 1 | Jan 9th, 2008 17:22 |
| How can I add in a 3rd column in on the right like the one on the left ? | nizmotine | Web Page Design | 7 | Aug 13th, 2007 12:28 |
| Forum Rename | JacobHaug | Flash & Multimedia Forum | 3 | May 27th, 2007 19:51 |
| ..copy data from column A in Table A to column B in Table B? | gecastill | Databases | 10 | Jun 23rd, 2005 18:27 |
