SQL Server queries table structure information-convenient Export

-- Column_name column name

-- Column_data_type

-- Max_length

-- The number of valid precision digits is similar to that of decimal.

-- Scale ratio

-- Whether is_nullable can be empty

--EMPIs the name of the queried table.

 

Select C. Name as column_name, P. [name] As column_data_type, C. max_length, P. [precision], p. Scale, P. is_nullable
From SYS. Columns C
Inner join SYS. Tables t on C. [object_id] = T. [object_id]
Left join SYS. types P on C. [user_type_id] = P. [user_type_id]
Left join SYS. computed_columns A on C. [object_id] = A. [object_id] and C. [column_id] = A. [column_id]
Left join SYS. default_constraints B on C. [object_id] = B. [parent_object_id] and C. [default_object_id] = B. [object_id]
Where T. [name] ='Emp'