http://www.sqle.ru/index.php?action=history&feed=atom&title=SQL_Server%2FT-SQL_Tutorial%2FSystem_Tables_Views%2Fsysindexes SQL Server/T-SQL Tutorial/System Tables Views/sysindexes - История изменений 2026-05-24T13:06:52Z История изменений этой страницы в вики MediaWiki 1.30.0 http://www.sqle.ru/index.php?title=SQL_Server/T-SQL_Tutorial/System_Tables_Views/sysindexes&diff=6919&oldid=prev в 13:46, 26 мая 2010 2010-05-26T13:46:16Z <p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr style="vertical-align: top;" lang="ru"> <td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td> <td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:46, 26 мая 2010</td> </tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div> </td></tr></table> http://www.sqle.ru/index.php?title=SQL_Server/T-SQL_Tutorial/System_Tables_Views/sysindexes&diff=6920&oldid=prev Admin: 1 версия 2010-05-26T10:24:45Z <p>1 версия</p> <p><b>Новая страница</b></p><div>== returns space usage information==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> 7&gt; SELECT name = CONVERT(CHAR(30), o.name), rows, dpages, o.id, type<br /> 8&gt; FROM sysindexes i JOIN sysobjects o ON o.id = i.id<br /> 9&gt; WHERE o.id &lt; 100 AND (indid = 0 OR indid = 1)<br /> 10&gt; GO<br /> 1&gt;<br /> 2&gt;&lt;/source&gt;<br /> <br /> <br /> <br /> == select FROM sysindexes WHERE id = object_id(&quot;HasText&quot;)==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> 3&gt; CREATE TABLE HasText<br /> 4&gt; (<br /> 5&gt; Col1 char(3) NOT NULL,<br /> 6&gt; Col2 text NOT NULL,<br /> 7&gt; Col3 varchar(5) NULL,<br /> 8&gt; Col4 varchar(20) NOT NULL,<br /> 9&gt; Col5 smallint NULL<br /> 10&gt; )<br /> 11&gt; GO<br /> 1&gt;<br /> 2&gt; INSERT HasText VALUES<br /> 3&gt; (&quot;AAA&quot;, REPLICATE(&quot;X&quot;, 250), NULL, &quot;ABC&quot;, 123)<br /> 4&gt; GO<br /> (1 rows affected)<br /> 1&gt;<br /> 2&gt; SELECT indid, first, name FROM sysindexes<br /> 3&gt; WHERE id = object_id(&quot;HasText&quot;)<br /> 4&gt; GO<br /> indid first<br /> name<br /> ------ -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /> ------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------<br /> --------------------------------------------------<br /> 0 0x7E0000000100<br /> NULL<br /> <br /> (1 rows affected)<br /> 1&gt;<br /> 2&gt;<br /> 3&gt; drop table HasText;<br /> 4&gt; GO<br /> 1&gt;&lt;/source&gt;<br /> <br /> <br /> <br /> == table sysindexes contains a row for each index and a row for each table without a clustered index.==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> 3&gt;<br /> 4&gt; select top 10 * from sysindexes;<br /> 5&gt; GO<br /> id status first<br /> indid root<br /> <br /> minlen keycnt groupid dpages reserved used rowcnt rowmodctr reserved3 reserved4 xmaxlen maxirow OrigFillFact<br /> or StatVersion reserved2 FirstIAM<br /> impid lockflags pgmodctr keys<br /> <br /> name<br /> statblob<br /> maxlen rows<br /> ----------- ----------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /> ------------------------------------------------------------------------------------------------------------------------------------------ ------ ------------------------------------------------------<br /> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /> ------------------------------------------------------------ ------ ------ ------- ----------- ----------- ----------- -------------------- ----------- --------- --------- ------- ------- ------------<br /> -- ----------- ----------- -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /> --------------------------------------------------------------------------------------------------------------------------------------------- ------ --------- ----------- -----------------------------<br /> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /> ------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------<br /> -------------- -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /> --------------------------------------------------------------------------------------------------------------------------------- ----------- -----------<br /> 4 18 0x0F0000000100<br /> 1 0x6C0000000100<br /> <br /> 34 2 1 7 9 9 697 1179600 0 0 37 19<br /> 0 0 0 0x930000000100<br /> 0 0 0 NULL<br /> <br /> clust<br /> NULL<br /> 8000 697<br /> 5 18 0x100000000100<br /> 1 0x100000000100<br /> <br /> 39 1 1 1 2 2 102 742 0 0 42 15<br /> 0 0 0 0xA70000000100<br /> 0 0 0 NULL<br /> <br /> clust<br /> NULL<br /> 8000 102<br /> 7 18 0x130000000100<br /> 1 0x780100000100<br /> <br /> 69 1 1 2 4 4 113 744 0 0 73 15<br /> 0 0 0 0x140000000100<br /> 0 0 0 NULL<br /> <br /> clust<br /> NULL<br /> 8000 113<br /> 8 0 0x200000000100<br /> 0 0x200000000100<br /> <br /> 786 0 1 1 2 2 2 4 0 0 789 0<br /> 0 0 0 0x0D0000000100<br /> 0 0 0 NULL<br /> <br /> NULL<br /> NULL<br /> 8000 2<br /> 13 18 0x110000000100<br /> 1 0x150000000100<br /> <br /> 41 2 1 7 15 9 697 4341 0 0 45 19<br /> 0 0 0 0x940000000100<br /> 0 0 0 NULL<br /> <br /> clust<br /> NULL<br /> 8000 697<br /> 15 18 0x120000000100<br /> 1 0x120000000100<br /> <br /> 37 1 1 1 2 2 102 742 0 0 41 15<br /> 0 0 0 0x6F0000000100<br /> 0 0 0 NULL<br /> <br /> clust<br /> NULL<br /> 8000 102<br /> 25 18 0x000000000000<br /> 1 0x000000000000<br /> <br /> 61 1 1 0 0 0 0 0 0 0 65 15<br /> 0 0 0 0x000000000000<br /> 0 0 0 NULL<br /> <br /> clst<br /> NULL<br /> 8000 0<br /> 26 18 0x8A0300000100<br /> 1 0x960000000100<br /> <br /> 21 3 1 1 2 2 113 744 0 0 24 24<br /> 0 0 0 0x950000000100<br /> 0 0 0 NULL<br /> <br /> clust<br /> NULL<br /> 8000 113<br /> 27 18 0xB00200000100<br /> 1 0x460100000100<br /> <br /> 29 1 1 1 6 6 15 1 0 0 908 15<br /> 0 0 0 0x450100000100<br /> 0 0 0 NULL<br /> <br /> clst<br /> NULL<br /> 8000 15<br /> 27 2 0xB20200000100<br /> 2 0x440100000100<br /> <br /> 5 2 1 1 2 2 15 1 0 0 281 267<br /> 0 0 0 0x430100000100<br /> 0 0 0 NULL<br /> <br /> nc1<br /> NULL<br /> 8000 15<br /> (10 rows affected)<br /> 1&gt;&lt;/source&gt;</div> Admin