Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in SQL by (20.3k points)

I want to alter a table column to be nullable. I have used:

ALTER TABLE Merchant_Pending_Functions Modify NumberOfLocations NULL

This gives an error at Modify. What is the correct syntax?

1 Answer

0 votes
by (40.4k points)

Try this code:

ALTER TABLE Merchant_Pending_Functions ALTER COLUMNNumberOfLocations INT NULL

You can replace INT with your actual datatype.

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Jan 5 in SQL by Appu (6.1k points)
0 votes
1 answer
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94.1k users

Browse Categories

...