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" />
![]() |