name column varchar code example

Example 1: sql change column in existing table

'This adds 'NOT NULL' to excisting column counting in the table mytable'
ALTER TABLE mytable ALTER COLUMN counting INT NOT NULL;

Example 2: modify column name in tsql

sp_rename 'table_name.old_column', 'new_name', 'COLUMN';