ALTER TABLE tblAccount
ALTER COLUMN AccountNO VARCHAR(100) NULL
tblAccount in the query means - Table name.
AccountNO in the query means - Column name
VARCHAR(100) in the query means - Change column data type to VARCHAR(100)
NULL in the query means - Column is allowed to contain null values
Sunday, December 30, 2012
How to Change Column DataType in Sql Server Table
Subscribe to:
Post Comments (Atom)
No comments:
Write comments