Find out How many columns in Table of a same database

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...................

Himanshu Sharma
If you see Dreams then Get Success On Dreams.....