Posted by: cofi July 13, 2007
Login in to Rate this Post:
0 
? 
?
try this one to change the data type
ALTER TABLE
MODIFY (Number int(6) NOT NULL );
Try this one to rename the column Name
EXEC sp_rename
@objname = 'table_name.old_column_name',
@newname = 'new_column_name',
@objtype = 'COLUMN'