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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Altering column size
- Thread starter nkm
- Start date
expostfacto
Programmer
read the docs on alter table.
Carnage Blender. Over 40 million battles served.
Carnage Blender. Over 40 million battles served.
Hi
Assume the following:
You can modify the size like so:
This changes the size from varchar(100) to varchar(40)
Hope this helps.
-=-=-=-=-=-=-=-=-
For ease of reading, any posted CODE should be wrapped by [ignore][COLOR] and
[/ignore] tags.
Ex:
TGML reference: ]
Assume the following:
Code:
CREATE TABLE testing123 (
someField varchar(100)
)You can modify the size like so:
Code:
ALTER TABLE testing123 MODIFY someField varchar(40)This changes the size from varchar(100) to varchar(40)
Hope this helps.
-=-=-=-=-=-=-=-=-
For ease of reading, any posted CODE should be wrapped by [ignore][COLOR] and
Code:
Ex:
Code:
SELECT 1 from sysobjectsTGML reference: ]
- Status