How defaults affect NULL values  Dropping defaults

Chapter 13: Defining Defaults and Rules for Data

After creating a default

After you create a default, the source text describing the default is stored in the text column of the syscomments system table. Do not remove this information; doing so may cause problems for future versions of Adaptive Server. Instead, 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. Dropping defaults

View this book as PDF