Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
CHANGE COLUMN 2
- Thread starter Ann28
- Start date
-
1
- #2
-
1
- #3
BrianTyler
IS-IT--Management
I believe you will have to delete the column and add a new one, unless it is a VARCHAR.
If the column is already populated, you may have to do this in several pahses, using a temporary column name and moving the data around.
The fact that the column is now defined at 'the end' of the list of columns should not matter if your programs explicitly identify columns in Selects, Inserts etc.
Regards
Brian
If the column is already populated, you may have to do this in several pahses, using a temporary column name and moving the data around.
The fact that the column is now defined at 'the end' of the list of columns should not matter if your programs explicitly identify columns in Selects, Inserts etc.
Regards
Brian
- Status
Similar threads
- Locked
- Question