| |
_dbcolumns, _dbforeignkey, _dbprimarykey, _dbtables
| Format:
_dbcolumns (table-description) |
| Format:
_dbforeignkey (table-description [ , table-description ]) |
| Format:
_dbprimarykey (table-description) |
| Format:
_dbtypes ([ sql type]) |
Purpose:
Get data definition information about database tables and database types.
The table-description argument must be an object and
is usually an object field of the object returned by _dbtables().
Return Values:
All functions return an object.
|
Note:
These are heitml internal functions.
The contents of the objects returned by these functions are not documented here,
since they may change in future releases of heitml.
|
Example:
| input: |
<let t=_dbtables();
if !isempty(t);
forin i t;
if ContainsCase(t[i].tablename,"guestbook");break;/if;
/forin;
><? t[i].tablename> = (<? t[i] ",\n %tQnNn">)
columns = <? _dbcolumns(t[i])>
primary key = <? _dbprimarykey(t[i])>
</if>
DB-specific LONGVARCHAR type: <? _dbtypes(-1) >
| resulting output:
|
GUESTBOOK = (tablequalifier=null,
tableowner='HEIDEMO',
tablename='GUESTBOOK',
TABLETYPE='TABLE',
PRIVILEGES='SEL+UPD+DEL+INS+REF+IND+ALT+',
UNLOADED='NO',
SAMPLE_PERCENT=null)
columns =
| [0] | = | (tablequalifier=null, tableowner="HEIDEMO", tablename="GUESTBOOK", COLUMNNAME="GUEST_NAME", typename="CHAR", precision=50, scale=null, radix=null, NULLABLE=true) |
| [1] | = | (tablequalifier=null, tableowner="HEIDEMO", tablename="GUESTBOOK", COLUMNNAME="EMAIL", typename="VARCHAR", precision=50, scale=null, radix=null, NULLABLE=true) |
| [2] | = | (tablequalifier=null, tableowner="HEIDEMO", tablename="GUESTBOOK", COLUMNNAME="ADDRESS", typename="VARCHAR", precision=60, scale=null, radix=null, NULLABLE=true) |
| [3] | = | (tablequalifier=null, tableowner="HEIDEMO", tablename="GUESTBOOK", COLUMNNAME="COUNTRY", typename="VARCHAR", precision=60, scale=null, radix=null, NULLABLE=true) |
| [4] | = |
| tablequalifier | = | null |
| tableowner | = | "HEIDEMO" |
| tablename | = | "GUESTBOOK" |
| COLUMNNAME | = | "GUEST_COMMENT" |
| typename | = | "VARCHAR" |
| precision | = | 250 |
| scale | = | null |
| radix | = | null |
| NULLABLE | = | true |
|
|
| [5] | = |
| tablequalifier | = | null |
| tableowner | = | "HEIDEMO" |
| tablename | = | "GUESTBOOK" |
| COLUMNNAME | = | "GUEST_PASSWORD" |
| typename | = | "CHAR" |
| precision | = | 61 |
| scale | = | null |
| radix | = | null |
| NULLABLE | = | true |
|
|
|
primary key = ()
DB-specific LONGVARCHAR type:
| LONG | = |
| TYPE_NAME | = | "LONG" |
| DATA_TYPE | = | -1 |
| precision | = | 2147483647 |
| LITERAL_PREFIX | = | "'" |
| LITERAL_SUFFIX | = | "'" |
| CREATE_PARAMS | = | null |
| NULLABLE | = | 1 |
| CASE_SENSITIVE | = | 1 |
| SEARCHABLE | = | 0 |
| UNSIGNED_ATTRIBUTE | = | null |
| MONEY | = | 0 |
| AUTO_INCREMENT | = | null |
| LOCAL_TYPE_NAME | = | "LONG" |
| MINIMUM_SCALE | = | null |
| MAXIMUM_SCALE | = | null |
| SQL_DATA_TYPE | = | -1 |
| SQL_DATETIME_SUB | = | null |
| NUM_PREC_RADIX | = | null |
| INTERVAL_PRECISION | = | null |
| REMARKS | = | null |
|
|
|
|
This page was dynamically generated by the
web application development tool RADpage
of H.E.I.
© 1996-2008 H.E.I. All Rights Reserved.
|
