Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (6.1k points)

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

1 Answer

0 votes
by (12.7k points)

You can use the following code:

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

Kick-start your career in SQL with this perfect SQL Course by Intellipaat now!

Watch this video tutorial on how to become a professional in SQL.

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Jan 5, 2021 in SQL by Appu (6.1k points)

Browse Categories

...