How do you change a column to an existing table in MS SQL Server? code example

Example 1: alter table query sql server change column

ALTER TABLE table_name
  ALTER COLUMN column_name column_type;

Example 2: 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;

Tags:

Sql Example

Related