Files > SQLI_TABLE

name

SQLI_TABLE

number

1.5215

location

^DMSQ("T",

description

Descriptor of a set of table elements: Includes name and file no. (See SQLI_TABLE_ELEMENTS). Each ^DD(DA) represents a table in a relational model of FileMan. Further, each index represents a table. Each schema contains multiple tables. Each table contains just one primary key, but multiple columns, foreign keys and indicies.

Fields

#	Name	Location	Type	Details	Index	Description
.01	t name(+)	0;1	FREE TEXT		B	Table name must be a valid SQL identifier, unique by schema
1	t schema(+)	0;2	POINTER	1.521		IEN in SQLI_SCHEMA of the schema to which this table belongs.
2	t comment	0;3	FREE TEXT			A short description of the table
3	t master table	0;4	POINTER	1.5215	E	The table of which this table is an index. (Only index tables)
4	t version fm	0;5	NUMERIC			The version number is updated by FileMan when ^DD or ^DIC changes.
5	t row count	0;6	NUMERIC			This field should contain an estimate of the number of rows in the table
6	t file(+)	0;7	NUMERIC		C	FileMan file number from which table is derived.
7	t update	0;8	DATE-TIME			Date last updated.
8	t global	1;E1,245	FREE TEXT		D	Global variable name. {K} stands for a subscript E.g.: ^DIC(9.4,{K},3,{K},4,{K})