Metadata for Views
Posted: 09.02.2008, 07:27
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
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