CODE EXAMPLE FOR SQL

sql database column values restrict

/// retrict column name rptIntervalUnit to just accept the ff values (Minutes,Days and Hours)
ALTER TABLE REPORTMODULES
ADD CONSTRAINT CK_INTERVALUNIT CHECK (rptIntervalUnit IN('Minutes','Days','Hours'))