Find SQL Table Cloumn name, data type,  column size

select column_name, data_type, character_maximum_length char from information_schema.columns where table_name=’tblCountry’

Find IsIdentity true columns

SELECT * from information_schema.columns where columnproperty(object_id(table_name),column_name, ‘IsIdentity’)=1
and table_name=’personal’

Find IsIdentity False Columns

SELECT * from information_schema.columns where columnproperty(object_id(table_name),column_name, ‘IsIdentity’)=0
and table_name=’personal’