Need to Alter Required property to No in SQL

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Thank you.

Allen Browne said:
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.
Click to expand...
 
Back
Top