°íÀ¯ »öÀÎ ID ºÐ¼® »ç¿ë

ID ºÐ¼®±âÀÇ ±âº» µ¿ÀÛÀÎ °íÀ¯ »öÀÎ ºÐ¼®Àº ºÐ¼® ÁßÀÎ Å×À̺íÀÇ Æ¯¼º ÆÄÀÏ¿¡ Ç׸ñÀÌ ¾ø´Â °æ¿ì ¶Ç´Â Ư¼º ÆÄÀÏÀÌ ¾ø´Â °æ¿ì »ç¿ëµË´Ï´Ù. °íÀ¯ »öÀÎ ºÐ¼®Àº ½Äº°ÀÚ¸¦ ã´Â ¼ö´ÜÀ¸·Î Å×ÀÌºí¿¡ ÁöÁ¤µÈ °íÀ¯ »öÀÎ Áß ÀϺθ¦ »ç¿ëÇÕ´Ï´Ù.

µ¥ÀÌÅͺ£À̽º ³»¿ëÀ» °»½ÅÇÏ·Á¸é µ¥ÀÌÅͺ£À̽º 1Â÷ Å×À̺íÀÇ °íÀ¯ ۸¦ ¾Ë¾Æ¾ß ÇÕ´Ï´Ù. µ¥ÀÌÅͺ£À̽º¸¦ Á¶È¸ÇÏ¸é °íÀ¯ »öÀÎÀ» ã¾Æ³¾ ¼ö ÀÖ½À´Ï´Ù. ¿¹¸¦ µé¾î, °íÀ¯ Ű °Ë»ö¿ë DB2 ¸í·ÉÀº ´ÙÀ½°ú °°½À´Ï´Ù. 

db2 describe indexes for table schema.tablename show detail

°íÀ¯ »öÀÎ ºÐ¼®ÀÇ ÀϺΠ¿¹

  °á°ú ÀÌÀü

  <MEMBER
    MEMBER_ID="100"
    TYPE="O"
    STATE="1"
  />

  <CATALOG
    DESCRIPTION="Winter Catalog"
    IDENTIFIER="WC2001"
    MEMBER_ID="100"
    TPCLEVEL="2"
  />

  <CATALOGDSC
    CATALOG_ID="@WC2001@100"            ±¸¼º¿ø "100"ÀÇ 
                                        īŻ·Î±× "WC2001" ÂüÁ¶(ÁÖ: ¼ø¼­°¡ Áß¿äÇÕ´Ï´Ù.)
    FULLIMAGE="c:\store\img\wc.gif"
    LANGUAGE_ID="-1"
    LONGDESCRIPTION="2001 Winter Catalog"
    SHORTDESCRIPTION="2001 Winter Catalog"
    NAME="InFashion 2001 Winter Catalog"
    THUMBNAIL="c:\store\img\wc_th.gif"
  />

  °á°ú ÀÌÈÄ

  <MEMBER
    MEMBER_ID="100"
    TYPE="O"
    STATE="1"
  />
  <CATALOG
    CATALOG_ID="10351"                 ÀÚµ¿À¸·Î »ý¼ºµÈ 1Â÷ Ű
    DESCRIPTION="Winter Catalog"
    IDENTIFIER="WC2001"
    MEMBER_ID="100"
    TPCLEVEL="2"
  />
  <CATALOGDSC
    CATALOG_ID="10351"                 ¿Ã¹Ù¸¥ īŻ·Î±× ÂüÁ¶
    FULLIMAGE="c:\store\img\wc.gif"
    LANGUAGE_ID="-1"
    LONGDESCRIPTION="2001 Winter Catalog"
    SHORTDESCRIPTION="2001 Winter Catalog"
    NAME="InFashion 2001 Winter Catalog"
    THUMBNAIL="c:\store\img\wc_th.gif"
  />

°ü·Ã °³³ä

°ü·Ã ŽºÅ©

°ü·Ã ÂüÁ¶

IBM copyright