SQL obtains all field types and precision scripts of a specified data table.

-- SQL: obtain all the field types and precision scripts of the specified data table, and directly execute the following script.
Select a. Name,
Case A. Precision
When 0 then

Case A. is_ansi_padded
When 1 then
Convert (nvarchar (15), B. Name + '(' + convert (nvarchar (10), a. max_length) + ')')
When 0 then
B. Name
End
Else

Case A. Scale
When 0 then
B. Name
Else
B. Name + '(' + convert (nvarchar (10), a. Precision) + ',' + convert (nvarchar (10), a. Scale) + ')'
End

End
As typelength from sys. columns A left join sys. types B on. system_type_id = B. system_type_id and. user_type_id = B. user_type_id where. object_id = (select object_id from sys. objects where name = 'name of an existing data table in the current database ');

 

The obtained results are in the following format:

Djbh char (15)

Dj_sort int

Lingsshl decimal (14,3)