20.03.2014 23:05, Leyne, Sean wrote: > I think you missed: > > - Can/should user create additional columns in System tables? (ie. > Create_datetime, Change_datetime -- for a simple schema change tracking > function) > > - Can/should user create their own triggers on System tables? (i.e. to detect > row changes and set the above Create_datetime and Change_datetime)
That's what DDL triggers are for. They can write change log to a user table, no need to touch system ones. -- WBR, SD. ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/13534_NeoTech Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
