syscat.out

derby database source code.good for you.

ij> --
-- this test shows the system catalogs
--
-- It is a goal of this test not to display information that
-- can (and will!) change from run to run, such as fields
-- that may eventually be UUIDs or UUID-like.
--
maximumdisplaywidth 500;
ij> -- negative tests
-- verify no user ddl allowed on system tables
-- drop table
drop table sys.systables;
ERROR X0Y56: 'DROP TABLE' is not allowed on the System table 'SYS.SYSTABLES'.
ij> -- drop index
drop index sys.sysaliases_index2;
ERROR 42X62: 'DROP INDEX' is not allowed in the 'SYS' schema.
ij> -- create index
create index trash on sys.systables(tableid);
ERROR 42X62: 'CREATE INDEX' is not allowed in the 'SYS' schema.
ij> -- system tables are not updateable
autocommit off;
ij> delete from sys.systables;
ERROR 42Y25: 'SYS.SYSTABLES' is a system table.  Users are not allowed to modify the contents of this table.
ij> update sys.systables set tablename = tablename || 'trash';
ERROR 42Y25: 'SYS.SYSTABLES' is a system table.  Users are not allowed to modify the contents of this table.
ij> insert into sys.systables select * from sys.systables;
ERROR 42Y25: 'SYS.SYSTABLES' is a system table.  Users are not allowed to modify the contents of this table.
ij> get cursor c as 'select tablename from sys.systables for update of tablename';
ERROR 42Y90: FOR UPDATE is not permitted in this type of statement.  
ij> -- users not allowed to do ddl in sys schema
create table sys.usertable(c1 int);
ERROR 42X62: 'CREATE TABLE' is not allowed in the 'SYS' schema.
ij> create view sys.userview as values 1;
ERROR 42908: The CREATE VIEW statement does not include a column list.
ij> rollback work;
ij> autocommit on;
ij> -- positive tests
create function gatp(SCH VARCHAR(128), TBL VARCHAR(128)) RETURNS VARCHAR(1000)
EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.TestPropertyInfo.getAllTableProperties'
LANGUAGE JAVA PARAMETER STYLE JAVA;
0 rows inserted/updated/deleted
ij> create function gaip(SCH VARCHAR(128), TBL VARCHAR(128)) RETURNS VARCHAR(1000)
EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.TestPropertyInfo.getAllIndexProperties'
LANGUAGE JAVA PARAMETER STYLE JAVA;
0 rows inserted/updated/deleted
ij> -- get the properties for the heaps
select tablename,gatp('SYS',