Answer / harshad

select count(*) from information.schema.columns
where table_name='tablename'

//where tablename is name of your sql table.
//do not prefix table name with .dbo

Answer / mohan

Guys.. Why don;t you try for the Columns bided with User
Defined Data Type and try the above queries... and Also try
for the Auto incremented Columns..(Identity)....
Your opinion would change definately....
Try out...
I am sure it doesn't take account of UDT Binded Coulmns

Answer / ajit kumar nayak

select count(*) from syscolumns sy,Sysobjects so
where
sy.id =so.id
and so.name = <table name>

Answer / ram&saran

SELECT COUNT(*) FROM SYS.COLUMNS WHERE ID=(SELECT * FROM
SYS.OBJECT WHERE NAME='TABLENAME')

Answer / laxmi reddy

SELECT COUNT(COLUMN_NAME) FROM ALL_TAB_COLS WHERE
TABLE_NAME=<'TABLE_NAME'>;

Answer / ashutosh jha

select count (*) from tablename.

What does top operator do?

0 Answers  

What is the security model used in sql server 2005?

0 Answers  

What are the restrictions that views have to follow? : SQL Server Architecture

0 Answers  

Difference between Triggers and Stored Procedure

23 Answers   Claimat, HCL, Protech, Silgate,

What is pessimistic concurrency?

0 Answers  

Explain difference between control flow and data flow?

0 Answers  

What is the difference between distinct clause and group by clause?

2 Answers   HHH, Value Labs,

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

0 Answers  

What do you mean by an execution plan? How would you view it?

0 Answers  

What is sql server english query?

0 Answers  

What are the different index configurations a table can have?

0 Answers  

How to concatenate two binary strings together?

0 Answers