Thank you gentlemen. Tom
---------- Original Message ---------------------------------- From: Lawrence Lustig <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Sat, 11 Sep 2004 17:56:04 -0700 (PDT) >> I am wondering if I can delete all of the >> keys/indexs on a database by >> typing >> >> DELETE* FROM sys_constraints > >No. Must of the system tables (those having to do >with database structure) are not real tables at all -- >they are simply table-like views that allow you to >read data about the database. The SQL standard >specifies that database metadata should be accessible >through the same mechanism as the data itself is. > >You cannot write to those tables. >-- >Larry > >
