The current naming rules for "Database Object Naming Conventions" are missing prefix for "Check constraint". I prefer to name all constraints. Check constraints I name with prefix "_ck", and the special case "NOT NULL" I prefix "_nn".