wiki:database:h2

차이

문서의 선택한 두 판 사이의 차이를 보여줍니다.

차이 보기로 링크

--- wiki:database:h2 [2022/11/17 20:18]
dhan
+++ wiki:database:h2 [2023/06/28 13:48] (현재)
dhan
@@ 줄 76: / 줄 76: @@
 	TEXT VARCHAR(255) DEFAULT NULL,
 	CREATED_AT VARCHAR(64) DEFAULT NULL,
-	"SOURCE" VARCHAR(64) DEFAULT NULL,
+	"SOURCE" VARCHAR(256) DEFAULT NULL,
 	USERID VARCHAR(64) DEFAULT NULL,
 	USERSCREENNAME VARCHAR(64) DEFAULT NULL,
@@ 줄 84: / 줄 84: @@
 	USERPROFILEIMAGEURL VARCHAR(255) DEFAULT NULL,
 	USERSTATUSESCOUNT VARCHAR(11) DEFAULT NULL
+);
+</code>
+Instagram
+<code sql>
+CREATE TABLE PUBLIC.TB_INSTAGRAM (
+	ID VARCHAR(64) NOT NULL,
+	PERMALINK VARCHAR(1024) DEFAULT NULL,
+	CAPTION TEXT,
+	CREATED_TIME VARCHAR(64) DEFAULT NULL,
+	MEDIA_TYPE VARCHAR(64) DEFAULT NULL,
+	MEDIA_URL VARCHAR(1024) DEFAULT NULL,
+	THUMBNAIL_URL VARCHAR(1024) DEFAULT NULL,
+	USERNAME VARCHAR(64) DEFAULT NULL
 );
 </code>
@@ 줄 105: / 줄 119: @@
 </code>
+인덱스(INDEX) 추가, 조회
+<code sql>
+CREATE INDEX {인덱스명} ON {테이블명} ({컬럼명})
+-- 예시(온나라) --
+CREATE INDEX TB_BMS_DCT_ENF_2021_IDX ON PUBLIC.TB_BMS_DCT_ENF_2021 (DOCID,ENFDOCID);
+CREATE INDEX TB_BMS_DCT_ENF_2021_DOCID_IDX ON PUBLIC.TB_BMS_DCT_ENF_2021 (DOCID);
+CREATE INDEX TB_BMS_DCT_ENF_2021_ENFDOCID_IDX ON PUBLIC.TB_BMS_DCT_ENF_2021 (ENFDOCID)
+-- 인덱스 조회
+SELECT * FROM information_schema.CONSTRAINTS c WHERE TABLE_SCHEMA = 'PUBLIC' AND TABLE_NAME='{테이블명}'
+or
+SELECT * FROM INFORMATION_SCHEMA.INDEXES WHERE TABLE_NAME ='{테이블명}';
+</code>
 ===== Backup =====

/volume1/web/dokuwiki/data/attic/wiki/database/h2.1668683896.txt.gz · 마지막으로 수정됨: 2022/11/17 20:18 저자 dhan