Find Table Structure

[CptTom]

I can't remember the select command that will list all tables and their structure (fields). When I pull them into text with headers on, some of the field names concantenate.

Thanks

Larry

 

[rastorin]

Hi !!!

Try this select,

SELECT substr(a.COLUMN_ID, 1, 3),
substr(a.TABLE_NAME, 1, 30),
substr(a.COLUMN_NAME, 1, 30),
substr(a.DATA_TYPE, 1, 10), LPAD(DECODE(a.DATA_PRECISION,'',TO_CHAR(a.DATA_LENGTH), TO_CHAR(a.DATA_PRECISION)||'.'||TO_CHAR(a.DATA_SCALE)), 6),
LPAD(a.NULLABLE,3)
FROM user_tab_columns a,
user_catalog b
WHERE a.table_name = b.table_name
AND b.table_type = 'TABLE'
ORDER BY a.TABLE_NAME, a.COLUMN_ID;