Skip to content
Advertisement

Altering column size in SQL Server

How to change the column size of the salary column in the employee table from numeric(18,0) to numeric(22,5)

Advertisement

Answer

ALTER TABLE [Employee]
ALTER COLUMN [Salary] NUMERIC(22,5) NOT NULL

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement