Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
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
asked Jan 5 in SQL by Appu (6.1k points)
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94k users

Browse Categories

...