View Single Post
  #1 (permalink)  
Old 10-28-04, 18:30
The-Saint The-Saint is offline
Registered User
 
Join Date: Jan 2004
Posts: 30
Question "ALTER COLUMN ... TYPE" problem

table user_general has a field named user_name which is varchar(40) now. I want to make it varchar(15). Here is SQL I use:

ALTER TABLE user_general
ALTER COLUMN user_name TYPE varchar(15)

it gives me error:

SQL error:
ERROR: syntax error at or near "TYPE" at character 50
In statement:
ALTER TABLE user_general
ALTER COLUMN user_name TYPE varchar(15)
Reply With Quote