SELECT TOP 100 PERCENT T.table_name, C.column_name, C.column_name AS real_column_name, C.is_nullable, C.data_type, C.character_maximum_length, C.numeric_precision, C.numeric_scale, C.column_default, C.ordinal_position, COLUMNPROPERTY(OBJECT_ID(C.TABLE_NAME), C.COLUMN_NAME, 'IsIdentity') AS AutoIncrement, (SELECT COUNT(column_name) FROM information_schema.key_column_usage INNER JOIN information_schema.table_constraints ON information_schema.table_constraints.constraint_name = information_schema.key_column_usage.constraint_name WHERE information_schema.key_column_usage.table_name = T.table_name AND constraint_type = 'primary key' AND column_name = C.column_name) AS PrimaryKey, (SELECT COUNT(t1.table_name) FROM information_schema.constraint_column_usage T1 WHERE (t1.table_name = T.table_name) AND (t1.column_name = C.column_name)) AS ForeignKey 
FROM information_schema.tables T INNER JOIN information_schema.columns C ON T.table_name = C.table_name
WHERE (T.table_type = 'BASE TABLE') AND (T.table_name <> 'dtproperties')
ORDER BY T.table_name, C.ordinal_position