select 
c.name as ColumnName, type_name(c.system_type_id) as ColumnType, 
c.is_nullable as AllowNull, 
object_name(fkc.referenced_object_id) as RefTable, 
col_name(fkc.referenced_object_id,fkc.referenced_column_id) as RefColumn,
OBJECTPROPERTY(OBJECT_ID(kcu.constraint_name), 'IsPrimaryKey') as IsPK, 
max_length as Length
from sys.tables as t
inner join sys.columns c on c.object_id=t.object_id
left outer join sys.foreign_key_columns fkc on fkc.parent_column_id=c.column_id and fkc.parent_object_id=c.object_id
left outer join INFORMATION_SCHEMA.KEY_COLUMN_USAGE kcu on kcu.COLUMN_NAME=c.name and kcu.TABLE_NAME=object_name(c.object_id)
	where c.object_id=OBJECT_ID('City')

We walk in the dark places no others will enter
We stand on the bridge and no one may pass