Need to Alter Required property to No in SQL

[Guest]

I need to write a single SQL statement to alter the Required property of a
Long Integer Table Field (Column) from Yes to No.

I know how to do it in VBA, but this isn't an option in this case.

Thanx

Reanie

 

[Allen Browne]

Try altering the column like this:
strSQL = "ALTER TABLE MyTable ALTER COLUMN Choice LONG NOT NULL;"
CurrentProject.Connection.Execute strSQL

I doubt that query will execute through the query interface, since Access
natively uses DAO.

 

[Guest]

Thank you.

Try altering the column like this:
strSQL = "ALTER TABLE MyTable ALTER COLUMN Choice LONG NOT NULL;"
CurrentProject.Connection.Execute strSQL

I doubt that query will execute through the query interface, since Access
natively uses DAO.