There may be requirement that you need to find list of the columns of a table or tables. To find this you need to query DBC.COLUMNS data dictionary view.
Example:-
SELECT * FROM DBC.COLUMNS;
Above query will show all the tables and their columns.
If you know the table or view name then you can specify that in the where condition.
Example:-
SEKECT * FROM SBC.COLUMNS
WHERE TABLENAME = 'TABLE_NAME';
Example:-
SELECT * FROM DBC.COLUMNS;
Above query will show all the tables and their columns.
If you know the table or view name then you can specify that in the where condition.
Example:-
SEKECT * FROM SBC.COLUMNS
WHERE TABLENAME = 'TABLE_NAME';
