테이블정의서 추출쿼리

테이블 정의서 추출쿼리 -- 역공학 QUERY => 테이블 정의서 WITH V_PRIMARY_KEY AS ( SELECT A.TABLE_NAME , A.CONSTRAINT_TYPE , A.CONSTRAINT_NAME , B.COLUMN_NAME , B.POSITION FROM ALL_CONSTRAINTS A , ALL_CONS_COLUMNS B WHERE A.OWNER = 'LSMS' AND A.CONSTRAINT_TYPE = 'P' AND A.OWNER = B.OWNER AND A.CONSTRAINT_NAME = B.CONSTRAINT_NAME ORDER BY A.TABLE_NAME, A.CONSTRAINT_TYPE, A.CONSTRAINT_NAME, B.COLUMN_NAME, B.POSITION ) ..

2021.06.24