Select T.Name As TableName
  ,C.Name As ColumnName
  ,ST.Name As DataType
  ,C.Max_Length
  ,C.Precision
  ,C.Scale
  ,Case
     When C.Is_Nullable = 1
       Then ''
     When C.Is_Nullable = 0
       Then 'Not Null'
   End As Nullable
  ,Case
     When C.Is_Identity = 1
       Then 'Identity Field'
     When C.Is_Identity = 0
       Then ''
   End As Is_Identity
From Sys.Tables T Inner Join Sys.Columns C
    On T.Object_ID = C.Object_ID
  Inner Join Sys.Types ST
    On C.User_Type_ID = ST.User_Type_ID
Where T.Name = '<First Table Name Here>'
----------------------------------------
    Union All
----------------------------------------
Select T.Name
  ,C.Name
  ,ST.Name
  ,C.Max_Length
  ,C.Precision
  ,C.Scale
  ,Case
     When C.Is_Nullable = 1
       Then ''
     When C.Is_Nullable = 0
       Then 'Not Null'
   End
  ,Case
     When C.Is_Identity = 1
       Then 'Identity Field'
     When C.Is_Identity = 0
       Then ''
   End
From Sys.Tables T Inner Join Sys.Columns C
    On T.Object_ID = C.Object_ID
  Inner Join Sys.Types ST
    On C.User_Type_ID = ST.User_Type_ID
Where T.Name = '<Second Table Name Here...Copy the entire second query and paste for all additional tables>'