헤르메스 LIFE

SELECT NAME AS COLNAME , REMARKS , TYPENAME , COLTYPE , NULLS AS NULLABLE , LENGTH , SCALE , LONGLENGTH FROM SYSIBM.SYSCOLUMNS WHERE TBCREATOR = '테이블스키마' AND TBNAME = '테이블명' ORDER BY COLNO

DECLARE @TABLE_NAME NVARCHAR(50) = '테이블명'; SELECT D.COLORDER AS COLUMN_IDX /* Column Index */ , A.NAME AS TABLE_NAME /* Table Name */ , C.VALUE AS TABLE_DESCRIPTION /* Table Description */ , D.NAME AS COLNAME /* Column Name */ , E.VALUE AS COLDESC /* Column Description */ , F.DATA_TYPE AS COLTYPE /* Column Type */ , F.CHARACTER_OCTET_LENGTH AS COLLEN /* Column Length */ , D.SCALE AS SCALE /* Col..

테이블 정보( 테이블 Comment + 컬럼 Comment + PK ) + Camel 표기 SELECT A.COLUMN_NAME , SUBSTR(LOWER(A.COLUMN_NAME), 1,1) || SUBSTR(REPLACE(INITCAP(A.COLUMN_NAME), '_'), 2) AS INIT_COL_CAP_NAME , B.COMMENTS , CASE WHEN LENGTH(C.INDEX_NAME) > 0 THEN 'PK' ELSE '' END AS PK_DIV , D.COMMENTS TABLE_COMMENTS FROM ALL_TAB_COLUMNS A , ALL_COL_COMMENTS B , ALL_IND_COLUMNS C , ALL_TAB_COMMENTS D WHERE A.TABLE_NAME = B...

MySQL comment 설정 및 조회 Database 목록 조회 -- Database 목록 조회 SHOW DATABASES; Table 정보조회 (with comment) -- 테이블 목록 조회 SHOW TABLES; -- 'springboot' 계정의 'Product' 테이블 정보 SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'springboot' AND TABLE_NAME = 'Product' ; COLUMN 정보조회 (with comment) show columns from 테이블명; -- Product 테이블 컬럼정보 show columns from Product; /* Query를 통한 테이블정보 조회 */ SELECT TABLE..

1. 현재 계정의 테이블 목록을 보여줌. SELECT * FROM tab; SELECT * FROM ALL_TABLES WHERE TABLE_NAME LIKE '[TABLE명]' 2. 모든 계정의 테이블 목록을 보여줌. SELECT * FROM all_tables WHERE OWNER = SCOTT; SELECT * FROM user_tables; 3. SYNONYM 정보 SELECT * FROM ALL_SYNONYMS WHERE SYNONYM_NAME = 'SYNONYM명' ; 4. Procedure 목록 SELECT * FROM USER_PROCEDURES WHERE OBJECT_NAME LIKE '%[프로시저명]%' ; SELECT OBJECT_ID , OBJECT_TYPE , OBJECT_NAME..