http://www.sqle.ru/index.php?action=history&feed=atom&title=SQL_Server%2FT-SQL_Tutorial%2FSystem_Tables_Views%2Fsys.columns 2026-05-24T14:17:43Z История изменений этой страницы в вики MediaWiki 1.30.0 http://www.sqle.ru/index.php?title=SQL_Server/T-SQL_Tutorial/System_Tables_Views/sys.columns&diff=6935&oldid=prev 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/sys.columns&diff=6936&oldid=prev 2010-05-26T10:24:47Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>== Sys.columns contains a row for each column of an object that has columns, such as tables and views.==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> 6&gt;<br /> 7&gt; select * from Sys.columns;<br /> 8&gt; GO<br /> object_id name column_id system_type_id user_type_id max_length precisio<br /> n scale collation_name is_nullable is_ansi_padded is_rowguidcol is_identity is_compute<br /> d is_filestream is_replicated is_non_sql_subscribed is_merge_published is_dts_replicated is_xml_document xml_collection_id default_object_id rule_object_id<br /> ----------- -------------------------------------------------------------------------------------------------------------------------------- ----------- -------------- ------------ ---------- --------<br /> - ----- -------------------------------------------------------------------------------------------------------------------------------- ----------- -------------- ------------- ----------- ----------<br /> - ------------- ------------- --------------------- ------------------ ----------------- --------------- ----------------- ----------------- --------------<br /> 4 rowsetid 1 127 127 8 1<br /> 9 0 NULL 0 0 0 0<br /> 0 0 0 0 0 0 0 0 0 0<br /> 4 rowsetcolid 2 56 56 4 1<br /> 0 0 NULL 0 0 0 0<br /> 0 0 0 0 0 0 0 0 0 0<br /> 4 hobtcolid 3 56 56 4 1<br /> 0 0 NULL 0 0 0 0<br /> 0 0 0 0 0 0 0 0 0 0<br /> 4 status 4 56 56 4 1<br /> 0 0 0 0 0 0 0 0 1131151075 0<br /> 1135343109 pub_id 1 175 175 4<br /> 0 0 SQL_Latin1_General_CP1_CI_AS 0 1 0 0<br /> 0 0 0 0 0 0 0 0 0 0<br /> 1135343109 pub_name 2 167 167 40<br /> 0 0 SQL_Latin1_General_CP1_CI_AS 1 1 0 0<br /> 0 0 0 0 0 0 0 0 0 0<br /> 1135343109 city 3 167 167 20<br /> 0 0 SQL_Latin1_General_CP1_CI_AS 1 1 0 0<br /> 0 0 0 0 0 0 0 0 0 0<br /> 1135343109 state 4 175 175 2<br /> 0 0 SQL_Latin1_General_CP1_CI_AS 1 1 0 0<br /> 0 0 0 0 0 0 0 0 0 0<br /> 1135343109 country 5 167 167 30<br /> 0 0 SQL_Latin1_General_CP1_CI_AS 1 1 0 0<br /> 0 0 0 0 0 0 0 0 1183343280 0<br /> 1147151132 optname 1 231 256 256<br /> 0 0 SQL_Latin1_General_CP1_CI_AS 0 1 0 0<br /> 0 0 0 0 0 0 0 0 0 0<br /> 1147151132 value 2 104 104 1<br /> 1 0 NULL 0 0 0 0<br /> 0 0 0 0 0 0 0 0 0 0<br /> 1147151132 major_version 3 56 56 4 1<br /> 0 0 NULL 0 0 0 0<br /> 0 0 0 0 0 0 0 0 0 0<br /> 1147151132 minor_version 4 56 56 4 1<br /> 0 0 NULL 0 0 0 0<br /> 0 0 0 0 0 0 0 0 0 0<br /> 1147151132 revision 5 56 56 4 1<br /> 0 0 NULL 0 0 0 0<br /> 0 0 0 0 0 0 0 0 0 0<br /> 1147151132 install_failures 6 56 56 4 1<br /> 0 0 NULL 0 0 0 0<br /> 0 0 0 0 0 0 0 0 0 0<br /> 2025774274 AccountNum 1 56 56 4 1<br /> 0 0 NULL 0 0 0 0<br /> 0 0 0 0 0 0 0 0 0 0<br /> 2025774274 Amount 2 60 60 8 1<br /> 9 4 NULL 0 0 0 0<br /> 0 0 0 0 0 0 0 0 0 0<br /> 2041774331 AcountNum 1 56 56 4 1<br /> 0 0 NULL 0 0 0 0<br /> 0 0 0 0 0 0 0 0 0 0<br /> 2041774331 Amount 2 60 60 8 1<br /> 9 4 NULL 0 0 0 0<br /> 0 0 0 0 0 0 0 0 0 0<br /> (580 rows affected)<br /> 1&gt;&lt;/source&gt;</div>

Admin