CREATE TABLE SYS.SYSCOLUMN (
	table_id	 UNSIGNED INT NOT NULL,
	column_id	 UNSIGNED INT NOT NULL,
	pkey	 CHAR(1) NOT NULL,
	domain_id	 SMALLINT NOT NULL,
	nulls	 CHAR(1) NOT NULL,
	width	 SMALLINT NOT NULL,
	scale	 SMALLINT NOT NULL,
	estimate	 INT NOT NULL,
	max_identity	 BIGINT NOT NULL,
	column_name	 CHAR(128) NOT NULL,
	remarks	 LONG VARCHAR,
	"default"	 	LONG VARCHAR,
	"check"	LONG VARCHAR,
	user_type		 SMALLINT,
	format_str	 CHAR(128),
	column_type CHAR(1) NOT NULL,
	remote_name VARCHAR(128),
	remote_type UNSIGNED INT,
	PRIMARY KEY ( table_id, column_id ),
	FOREIGN KEY REFERENCES SYS.SYSTABLE,
	FOREIGN KEY REFERENCES SYS.SYSDOMAIN
	FOREIGN KEY REFERENCES SYS.SYSUSERTYPE
)

CREATE VIEW SYS.SYSCOLUMNS ( creator, cname, tname,
coltype, nulls, length, syslength,
in_primary_key, "colno", default_value, remarks )
AS
SELECT ( SELECT user_name FROM SYS.SYSUSERPERM
			WHERE user_id = SYSTABLE.creator ),
		column_name, table_name,
		( SELECT domain_name FROM SYS.SYSDOMAIN
			WHERE domain_id = SYSCOLUMN.domain_id ),
		nulls, width, scale, pkey, column_id,
		"default", SYSCOLUMN.remarks
FROM SYS.SYSCOLUMN == SYS.SYSTABLE