Search results

I'm listening Lips!! Albeit a few years too late! Thanks anyway.

How do I set the Required property for field that already exists via SQL. I'm thinking along the lines of: ALTER TABLE table1 ALTER COLUMN field1 text(50) NOT REQUIRED. But this doesn't work, any clues?