SQL Server/T-SQL Tutorial/System Tables Views/sys.columns

Материал из SQL эксперт
Перейти к: навигация, поиск

Sys.columns contains a row for each column of an object that has columns, such as tables and views.

6>
7> select * from Sys.columns;
8> GO
object_id   name                                                                                                                             column_id   system_type_id user_type_id max_length precisio
n scale collation_name                                                                                                                   is_nullable is_ansi_padded is_rowguidcol is_identity is_compute
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
----------- -------------------------------------------------------------------------------------------------------------------------------- ----------- -------------- ------------ ---------- --------
- ----- -------------------------------------------------------------------------------------------------------------------------------- ----------- -------------- ------------- ----------- ----------
- ------------- ------------- --------------------- ------------------ ----------------- --------------- ----------------- ----------------- --------------
          4 rowsetid                                                                                                                                   1            127          127          8        1
9     0 NULL                                                                                                                                       0              0             0           0
0             0             0                     0                  0                 0               0                 0                 0              0
          4 rowsetcolid                                                                                                                                2             56           56          4        1
0     0 NULL                                                                                                                                       0              0             0           0
0             0             0                     0                  0                 0               0                 0                 0              0
          4 hobtcolid                                                                                                                                  3             56           56          4        1
0     0 NULL                                                                                                                                       0              0             0           0
0             0             0                     0                  0                 0               0                 0                 0              0
          4 status                                                                                                                                     4             56           56          4        1
0             0             0                     0                  0                 0               0                 0        1131151075              0
 1135343109 pub_id                                                                                                                                     1            175          175          4
0     0 SQL_Latin1_General_CP1_CI_AS                                                                                                               0              1             0           0
0             0             0                     0                  0                 0               0                 0                 0              0
 1135343109 pub_name                                                                                                                                   2            167          167         40
0     0 SQL_Latin1_General_CP1_CI_AS                                                                                                               1              1             0           0
0             0             0                     0                  0                 0               0                 0                 0              0
 1135343109 city                                                                                                                                       3            167          167         20
0     0 SQL_Latin1_General_CP1_CI_AS                                                                                                               1              1             0           0
0             0             0                     0                  0                 0               0                 0                 0              0
 1135343109 state                                                                                                                                      4            175          175          2
0     0 SQL_Latin1_General_CP1_CI_AS                                                                                                               1              1             0           0
0             0             0                     0                  0                 0               0                 0                 0              0
 1135343109 country                                                                                                                                    5            167          167         30
0     0 SQL_Latin1_General_CP1_CI_AS                                                                                                               1              1             0           0
0             0             0                     0                  0                 0               0                 0        1183343280              0
 1147151132 optname                                                                                                                                    1            231          256        256
0     0 SQL_Latin1_General_CP1_CI_AS                                                                                                               0              1             0           0
0             0             0                     0                  0                 0               0                 0                 0              0
 1147151132 value                                                                                                                                      2            104          104          1
1     0 NULL                                                                                                                                       0              0             0           0
0             0             0                     0                  0                 0               0                 0                 0              0
 1147151132 major_version                                                                                                                              3             56           56          4        1
0     0 NULL                                                                                                                                       0              0             0           0
0             0             0                     0                  0                 0               0                 0                 0              0
 1147151132 minor_version                                                                                                                              4             56           56          4        1
0     0 NULL                                                                                                                                       0              0             0           0
0             0             0                     0                  0                 0               0                 0                 0              0
 1147151132 revision                                                                                                                                   5             56           56          4        1
0     0 NULL                                                                                                                                       0              0             0           0
0             0             0                     0                  0                 0               0                 0                 0              0
 1147151132 install_failures                                                                                                                           6             56           56          4        1
0     0 NULL                                                                                                                                       0              0             0           0
0             0             0                     0                  0                 0               0                 0                 0              0
 2025774274 AccountNum                                                                                                                                 1             56           56          4        1
0     0 NULL                                                                                                                                       0              0             0           0
0             0             0                     0                  0                 0               0                 0                 0              0
 2025774274 Amount                                                                                                                                     2             60           60          8        1
9     4 NULL                                                                                                                                       0              0             0           0
0             0             0                     0                  0                 0               0                 0                 0              0
 2041774331 AcountNum                                                                                                                                  1             56           56          4        1
0     0 NULL                                                                                                                                       0              0             0           0
0             0             0                     0                  0                 0               0                 0                 0              0
 2041774331 Amount                                                                                                                                     2             60           60          8        1
9     4 NULL                                                                                                                                       0              0             0           0
0             0             0                     0                  0                 0               0                 0                 0              0
(580 rows affected)
1>