hello friends,
I declaring a new query for finding out how many columns of a table in the same database
select * from sys.columns where object_name(object_id)='table name'
for example
select * from sys.columns where object_name(object_id)='resale'
I hope you will get better knowledge...................