what information can I get from the sys.column table in SQL?

Question

I'm looking for column attributes.

Answer 1

The documentation is here. What additional information are you looking for or what is not clear?

Answer 2

Hi there Cook, Daniel

Thanks for using QandA platform

The following is a list of object types that have columns:

• Table-valued assembly functions (FT)
• Inline table-valued SQL functions (IF)
• Internal tables (IT)
• System tables (S)
• Table-valued SQL functions (TF)
• User tables (U)
• Views (V)

for more info I have given the link below and if you have any specific question let us know,

https://learn.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-columns-transact-sql?view=sql-server-ver16

Answer 3

And what's the exact proble? You get all informations for DMV sys.columns, see

https://learn.microsoft.com/de-de/sql/relational-databases/system-catalog-views/sys-columns-transact-sql?view=sql-server-ver16