DB Table Column 이름 가져오기.

SELECT column_name
FROM information_schema.columns
WHERE table_name = '테이블명';
SELECT column_name
FROM user_tab_cols
WHERE table_name = '테이블명';

select concat('public object ', column_name, ' { get; set;}')
from information_schema.COLUMNS
where table_name = '테이블명' and table_schema = 'DB명'
/* 결과값 :: 복사 후 자료 형만 적절하게 교체 */
public object SEQUNCE {get;set;}
public object LEVEL {get;set;}
public object MENU_REG {get;set;}
public object MENU_RENT {get;set;}
public object MENU_SEARCH {get;set;}
public object MENU_ANALYZE {get;set;}
public object MENU_DEL {get;set;}
public object MENU_MATCH {get;set;}
public object USER_NM {get;set;}
public object USER_ID {get;set;}
public object USER_PW {get;set;}
public object START_DATE {get;set;}
public object END_DATE {get;set;}
  • 2023년 7월 28일