Metadata for Views

[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

[mdaems]

If you get it working... why not? It may also be useful for aliases and synonyms.