You cannot change a character column to numeric and vice versa. To change a column's data type, drop the column and then add it (and its data) again, or use the DATA step. Note: You cannot change the ...

Truncate_table_on_publisher.sql - Truncate table which contains database file size information. ... 60_Change_datatype_on_subscriber.sql - Perform all database related activities like data type change ...

ALTER TABLE ALTER COLUMN TYPE doesn't work for some corner cases ... C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. Code not up to spec/doc, ...

ALTER TABLE . With ALTER TABLE you can add or delete columns in an existing table. When you add a column you must specify a data type. ALTER TABLE table_name ADD col_name datatype ALTER TABLE ...