Find out How many columns in Table of a same database

Dotnet4ashu
Posted by Dotnet4ashu under Sql Server category on | Points: 40 | Views : 1212
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...................

Comments or Responses

Posted by: Pragati on: 6/4/2012 Level:Starter | Status: [Member] | Points: 10
hi..
how can we find out how many columns of a table in the same database in oracle...
Posted by: dhirenkaunar-15094 on: 6/12/2012 Level:Starter | Status: [Member] | Points: 10
Pragati,
Please find the below link which may be the answer of your question
http://www.dotnetfunda.com/codes/code2653-how-to-find-number-of-column-in-a-table-in-different-database.aspx

Login to post response