http://www.sqle.ru/index.php?action=history&feed=atom&title=SQL_Server%2FT-SQL%2FSystem%2Fcolumns
SQL Server/T-SQL/System/columns - История изменений
2026-04-04T12:00:59Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://www.sqle.ru/index.php?title=SQL_Server/T-SQL/System/columns&diff=5898&oldid=prev
в 13:46, 26 мая 2010
2010-05-26T13:46:06Z
<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/System/columns&diff=5899&oldid=prev
Admin: 1 версия
2010-05-26T10:20:38Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==table syscolumns appears in the master database and in every user-defined database.==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
<br />
It contains a row for every column of a base table or a view and a row for each parameter in a stored procedure.<br />
7><br />
8> select top 10 * from syscolumns;<br />
9> GO<br />
name id xtype typestat xusertype length xprec xscale colid xoffset<br />
bitpos reserved colstat cdefault domain number colorder autoval<br />
offset collationid l<br />
anguage status type usertype printfmt<br />
prec scale iscomputed isoutparam isnullable collation<br />
tdscollation<br />
<br />
-------------------------------------------------------------------------------------------------------------------------------- ----------- ----- -------- --------- ------ ----- ------ ------ -------<br />
------ -------- ------- ----------- ----------- ------ -------- ---------------------------------------------------------------------------------------------------------------------------------------<br />
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br />
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------ ----------- -<br />
---------- ------ ---- -------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br />
--------------------------------------------------------------------------------------- ------ ----------- ----------- ----------- ----------- ---------------------------------------------------------<br />
----------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------<br />
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br />
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br />
rowsetid 4 127 1 127 8 19 0 1 0<br />
0 0 0 0 0 0 1 NULL<br />
0 0<br />
0 0 63 0 NULL<br />
19 0 0 0 0 NULL<br />
0x0000000000<br />
<br />
rowsetcolid 4 56 1 56 4 10 0 2 0<br />
0 0 0 0 0 0 2 NULL<br />
0 0<br />
0 0 56 7 NULL<br />
10 0 0 0 0 NULL<br />
0x0000000000<br />
<br />
hobtcolid 4 56 1 56 4 10 0 3 0<br />
0 0 0 0 0 0 3 NULL<br />
0 0<br />
0 0 56 7 NULL<br />
10 0 0 0 0 NULL<br />
0x0000000000<br />
<br />
status 4 56 1 56 4 10 0 4 0<br />
0 0 0 0 0 0 4 NULL<br />
0 0<br />
0 0 56 7 NULL<br />
10 0 0 0 0 NULL<br />
0x0000000000<br />
<br />
rcmodified 4 127 1 127 8 19 0 5 0<br />
0 0 0 0 0 0 5 NULL<br />
0 0<br />
0 0 63 0 NULL<br />
19 0 0 0 0 NULL<br />
0x0000000000<br />
<br />
maxinrowlen 4 52 1 52 2 5 0 6 0<br />
0 0 0 0 0 0 6 NULL<br />
0 0<br />
0 0 52 6 NULL<br />
5 0 0 0 0 NULL<br />
0x0000000000<br />
<br />
rowsetid 5 127 1 127 8 19 0 1 0<br />
0 0 0 0 0 0 1 NULL<br />
0 0<br />
0 0 63 0 NULL<br />
19 0 0 0 0 NULL<br />
0x0000000000<br />
<br />
ownertype 5 48 1 48 1 3 0 2 0<br />
0 0 0 0 0 0 2 NULL<br />
0 0<br />
0 0 48 5 NULL<br />
3 0 0 0 0 NULL<br />
0x0000000000<br />
<br />
idmajor 5 56 1 56 4 10 0 3 0<br />
0 0 0 0 0 0 3 NULL<br />
0 0<br />
0 0 56 7 NULL<br />
10 0 0 0 0 NULL<br />
0x0000000000<br />
<br />
idminor 5 56 1 56 4 10 0 4 0<br />
0 0 0 0 0 0 4 NULL<br />
0 0<br />
0 0 56 7 NULL<br />
10 0 0 0 0 NULL<br />
0x0000000000<br />
<br />
(10 rows affected)<br />
</source><br />
<br />
<br />
<br />
<br />
==Using system table: columns==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
USE Northwind<br />
GO<br />
1><br />
2> DECLARE @TBLName nvarchar(128)<br />
3> SET @TBLName = N"Shippers"<br />
4><br />
5> SELECT name, object_id FROM sys.tables WHERE name = @TBLName<br />
6><br />
7> SELECT name, column_id, object_id<br />
8> FROM sys.columns<br />
9> WHERE object_id IN<br />
10> (SELECT object_id<br />
11> FROM sys.tables<br />
12> WHERE name = @TBLName)<br />
13><br />
14> GO<br />
<br />
</source></div>
Admin