How to get column details in SQL from Siebel DB

Below query will return column details:

SELECT COL.ROW_ID AS 'Column Id'
,COL.NAME AS 'Column Name'
,COL.LENGTH AS 'Column Length'
,TAB.NAME AS 'Table Name'

FROM S_COLUMN COL
LEFT JOIN S_TABLE TAB ON TAB.ROW_ID = COL.TBL_ID

WHERE 1=1