Sqlserver obtains the type and number of bytes of the names and column names of all tables in the database.

obtain the type and number of bytes of the names and column names of all tables in the database.

  select  
. name  as  table name, 
 B. name  as  column name, 
 C. name  as  type, 
 B. max_length  as , 
 B.  precision   as  integer, 
 B. scale  as  decimal places 
  from  sys. tables A 
  Inner   join  sys. columns B  On .  object_id  = B.  object_id  
  Inner   join  sys. types 
 C  On  C. user_type_id = B. user_type_id 

In which table can we query detailed information such as the type of the field?

 Select 
A. Name As Table Name,
B. Name As Column name,
C. Name As Type,
B. max_length As Number of bytes,
B. Precision   As Integer,
B. Scale As Decimal places
 From SYS. Tables
Inner   Join SYS. columns B On A. Object_id  = B. Object_id 
 Inner   Join SYS. Types
C On C. user_type_id = B. user_type_id Where A. Name =  '  Table Name '   And B. Name =  '  Column name  '