Reserved columns  Triggers on system tables

Chapter 1: System Tables

Updating system tables

Direct updates on system tables are not allowed—even for the Database Owner. Instead, Adaptive Server includes system procedures that you should use to make any normally needed updates and additions to system tables.

You can allow direct updates to the system tables if it you must modify them in a way that cannot be accomplished with a system procedure. To allow direct udpates, a System Security Officer must use sp_configure to reset the configuration parameter called allow updates to system tables. For more information, see the System Administration Guide.





Copyright © 2005. Sybase Inc. All rights reserved. Triggers on system tables

View this book as PDF