Need to Alter Required property to No in SQL

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

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Reanie" wrote in message
...
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

Thank you.

"Allen Browne" wrote:

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Reanie" wrote in message
...
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