declare @table_name varchar(255) = 'tc_trip_zakaz'
select
  t_c.COLUMN_NAME                             					    as name
  , t_c.DATA_TYPE                                                     as type
  , isnull(t_c.CHARACTER_MAXIMUM_LENGTH, 0)					        as max_length
  , case when lower(t_c.IS_NULLABLE) = 'yes'    then  1 else 0 end    as is_nullable
  , isnull(s.is_unique, 0) as is_unique
  , isnull(s.is_foreign, 0) as is_foreign
  , isnull(s.is_primary, 0) as is_primary
from INFORMATION_SCHEMA.COLUMNS									as  t_c
left join INFORMATION_SCHEMA.KEY_COLUMN_USAGE				as all_keys
                 on all_keys.TABLE_NAME = t_c.TABLE_NAME
                 and t_c.COLUMN_NAME    = all_keys.COLUMN_NAME
 left join (
  select
    CONSTRAINT_NAME as keys
       , case when CONSTRAINT_TYPE = 'UNIQUE'      then 1 else 0 end as is_unique
       , case when CONSTRAINT_TYPE = 'FOREIGN KEY' then 1 else 0 end as is_foreign
       , case when CONSTRAINT_TYPE = 'PRIMARY KEY' then 1 else 0 end as is_primary
  from
    INFORMATION_SCHEMA.TABLE_CONSTRAINTS as  f_key where TABLE_NAME = @table_name

) as s ON s.keys = all_keys.CONSTRAINT_NAME

where t_c.TABLE_NAME = @table_name