Altering column size in SQL Server?

Question

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

Answer 1

ALTER TABLE Employee ALTER COLUMN "salary" numeric(22,5)

First we establish which table we're about to manipulate using the ALTER TABLE command. If I understand you correctly, it is not your goal to change the column size but rather the data type of the column. This is where ALTER COLUMN comes into play. This version is for SQL Server. MySQL and Oracle are similar but use MODIFY instead. I hope this answered your question and helped you understand a little more.