After creating a check constraint

When you create a check constraint, source text, which describes the check constraint, is stored in the text column of the syscomments system table.

WARNING! Do not remove this information from syscomments; doing so can cause problems for future upgrades of Adaptive Server.

If you have security concerns, encrypt the text in syscomments by using sp_hidetext, described in the Reference Manual: Procedures. See “Compiled objects”.