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’
