카페힐링

1. 테이블 정보 : SYS.SYSTABLE

2. 컬럼 정보 : SYS.SYSTABLE

3. 테이블의 컬럼 정보: 

SELECT A.TABLE_NAME AS TABLE_NAME 
      ,B.COLUMN_ID AS COL_ORDER
      ,B.COLUMN_NAME AS COL_NAME
  FROM SYS.SYSTABLE A, SYS.SYSCOLUMN B
 WHERE A.TABLE_ID = B.TABLE_ID 
   AND A.TABLE_NAME LIKE 'table_name'
 ORDER BY A.TABLE_NAME, B.COLUMN_ID