Page 1 of 1

Metadata for Views

Posted: 09.02.2008, 07:27
by sandeep_c24
The columns fetched for when getting metadata for tables are are

TABLE_CAT
TABLE_SCHEM
TABLE_NAME
TABLE_TYPE : "TABLE", "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM"
REMARKS

Should another column (SOURCE) be added to get the source for Views?

Regards

Sandeep

Posted: 09.02.2008, 20:34
by mdaems
If you get it working... why not? It may also be useful for aliases and synonyms.