Back

Explore Courses Blog Tutorials Interview Questions

Altering a column to be nullable

0 votes
2 views
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.7k 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
How to change a PG column to NULLABLE TRUE?
asked Jul 16, 2019 in SQL by Tech4ever (20.3k points)
0 votes
1 answer
Make column not nullable in a Laravel migration
asked Jul 25, 2019 in SQL by Tech4ever (20.3k points)
0 votes
1 answer
Altering column size in SQL Server
asked Jan 5, 2021 in SQL by Appu (6.1k points)
0 votes
1 answer
Altering column size in SQL Server
asked Jul 6, 2019 in SQL by Tech4ever (20.3k points)
0 votes
1 answer
Alter a MySQL column to be AUTO_INCREMENT
asked Jul 11, 2019 in SQL by Tech4ever (20.3k points)

Browse Categories

© COPYRIGHT 2011-2023 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

Download Salary Trends Now !

Learn how professionals like you got up to 100% Salary Hike.

...