Thursday, March 29, 2012

Datatype

Is it possible to modify Datatipe using ALTER TABLE?:confused:Yes, it is.

Example:

ALTER TABLE customers
ALTER COLUMN street_address
varchar(35)

If this doesn't help you, search Books Online for a more comprehensive help regarding ALTER TABLE.|||Thanks a lot, it works perfect!!