1.현재 DB에 Table 목록 확인 | SELECT * FROM INFORMATION_SCHEMA.TABLES; |
2.Table 정보확인(컬럼 및 상세정보) | SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='테이블이름'; |
3.Table 정보확인(키사용정보 확인) | SELECT * FROM INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE WHERE TABLE_NAME='테이블이름'; SELECT * FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE TABLE_NAME='테이블이름'; |
4.특정 Table의 주키 뽑기 | SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE TABLE_NAME='테이블이름' AND CONSTRAINT_NAME=(SELECT CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE TABLE_NAME='테이블이름' AND CONSTRAINT_TYPE='PRIMARY KEY'); |