Creating error messages for constraints  Specifying default column values

Chapter 8: Creating Databases and Tables

After creating a check constraint

After you create a check constraint, the source text describing the check constraint is stored in the text column of the syscomments system table. 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. For more information, see “Compiled objects”.





Copyright © 2005. Sybase Inc. All rights reserved. Specifying default column values

View this book as PDF