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