CHECK CONSTRAINT blunder(s)

Hi,

Can someone clue me in as to proper syntax for adding a not null
check constraint?  I've fumbled around a bit without much luck
and I don't see this covered in the alter table section of the
interactive docs.

My pseudo code is:
ALTER TABLE doof ADD CONSTRAINT bleibt_doof NOT NULL (record_id);
But obviously this fails.

TIA - Cheers
-----------------------------------------------------------------------
Thomas Good                                  e-mail: tomg@sqlclinic.net
Programmer/Analyst                           phone:   (+1) 718.818.5528
Residential Services                         fax:     (+1) 718.818.5056
Behavioral Health Services, SVCMC-NY         mobile:  (+1) 917.282.7359
--                                                                   --
SQL Clinic - An Open Source Clinical Record           www.sqlclinic.net
------------------------------------------------------------------------