Hi, How can i modify the datatyp

[sssdexter]

Hi,

How can i modify the datatype? For example i like to change student_id from varchar(4) to varchar(8)?

Thanks a lot

 

[LakshmiKiran]

Hi,
This is how you do..
alter table tablename
alter column student_id varchar(8)


But you cannot set it to lesser length than already present.

 

[JamesLean]

FYI, you can actually set the length to less than any existing data by using SET ANSI_WARNINGS OFF for the connection.

Obviously this will cut off the end of any data that is longer than the new length, so you probably don't want to do this.

--James