TSQL - Get table columns, types, primary keys, etc

get table schema.sql

select 
      SchemaName = schema_name(t.schema_id)
    , TableName = t.name
    , ColumnName = c.name
    , IsPrimaryKey = (select count(*) from
                        sys.indexes as i join sys.index_columns as ic on i.OBJECT_ID = ic.OBJECT_ID and i.index_id = ic.index_id and ic.column_id = c.column_id
                        where i.is_primary_key = 1 and i.object_id = t.object_id)
    , ColumnType = TYPE_NAME(c.system_type_id)
    , MaxLength = c.max_length
from sys.tables t join sys.columns c on t.object_id = c.object_id
order by t.name , c.column_id