서

커리로 DB 테이블 명세서 출력하기

· 2016-01-21 (목) 14:04:19 · 2655

테이블 명세서를 간편하게 할수 있겠네요

 

SELECT

  ORDINAL_POSITION AS `번호`,

  COLUMN_NAME AS `필드명`,

  COLUMN_TYPE AS `속성`,

  IS_NULLABLE AS `NULL값여부`,

  COLUMN_KEY AS `KEY`,

  EXTRA AS `자동여부`,

  COLUMN_DEFAULT `기본값`,

  COLUMN_COMMENT AS `설명`

FROM

  INFORMATION_SCHEMA.COLUMNS 

WHERE

  TABLE_SCHEMA = 'DB 이름'

  AND TABLE_NAME = '테이블이름'

ORDER BY

  TABLE_NAME, ORDINAL_POSITION

댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,187건
+
제목 글쓴이 날짜 조회
16-02-06 조회 3,644
16-02-04 조회 3,202
16-02-04 조회 3,492
16-02-04 조회 3,195
16-02-03 조회 3,260
16-02-03 조회 3,007
16-02-03 조회 3,052
16-02-03 조회 2,969
16-02-03 조회 3,081
16-02-02 조회 3,118
16-02-02 조회 3,018
16-02-02 조회 3,041
16-02-02 조회 2,926
16-02-02 조회 3,338
16-02-01 조회 2,925
16-02-01 조회 2,733
16-02-01 조회 2,713
16-01-31 조회 2,738
16-01-31 조회 2,752
16-01-31 조회 2,754
16-01-30 조회 3,154
16-01-30 조회 2,753
16-01-30 조회 2,734
16-01-30 조회 2,932
16-01-30 조회 3,073
16-01-30 조회 2,871
16-01-29 조회 2,738
16-01-29 조회 2,739
16-01-29 조회 2,628
16-01-29 조회 2,612
16-01-28 조회 3,099
16-01-28 조회 2,947
16-01-28 조회 2,562
16-01-28 조회 2,467
16-01-28 조회 2,717
16-01-27 조회 2,652
16-01-27 조회 2,638
16-01-27 조회 2,637
16-01-26 조회 2,633
16-01-26 조회 2,610
16-01-26 조회 2,627
16-01-26 조회 2,928
16-01-25 조회 2,633
16-01-25 조회 2,680
16-01-25 조회 2,689
16-01-25 조회 2,561
16-01-24 조회 2,553
16-01-24 조회 2,553
16-01-24 조회 2,472
16-01-23 조회 2,520
16-01-23 조회 2,531
16-01-23 조회 2,507
16-01-22 조회 2,648
16-01-22 조회 2,763
16-01-22 조회 2,667
16-01-22 조회 2,750
16-01-21 조회 2,780
16-01-21 조회 2,656
16-01-21 조회 2,637
16-01-21 조회 2,643
16-01-21 조회 2,599
16-01-20 조회 2,642
16-01-20 조회 2,566
16-01-20 조회 2,516
16-01-20 조회 2,717
16-01-19 조회 2,541
16-01-19 조회 2,579
16-01-19 조회 2,566
16-01-19 조회 2,599
16-01-19 조회 2,792
16-01-18 조회 2,579
16-01-18 조회 2,568
16-01-18 조회 2,583
16-01-18 조회 2,733
16-01-17 조회 2,760
16-01-17 조회 2,612
16-01-17 조회 2,678
16-01-16 조회 2,517
16-01-16 조회 2,452
16-01-16 조회 2,513
16-01-15 조회 2,668
16-01-15 조회 2,664
16-01-15 조회 2,586
16-01-15 조회 2,519
16-01-14 조회 2,681
16-01-14 조회 2,820
16-01-14 조회 3,276
16-01-14 조회 2,571
16-01-14 조회 2,799
16-01-14 조회 2,603
16-01-13 조회 3,046
16-01-13 조회 2,661
16-01-13 조회 2,629
16-01-13 조회 2,658
16-01-13 조회 2,542
16-01-12 조회 2,964
16-01-12 조회 2,723
16-01-12 조회 2,728
16-01-12 조회 2,654
16-01-11 조회 2,776