Sys.columns contains a row for each column of an object that has columns, such as tables and views. : sys.columns « System Tables Views « SQL Server / T-SQL Tutorial
- SQL Server / T-SQL Tutorial
- System Tables Views
- sys.columns
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>
| 27.1.sys.columns |
| 27.1.1. | Sys.columns contains a row for each column of an object that has columns, such as tables and views. |