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.

Do you know the policy based administration feature of sql server 2008?

0 Answers  

What are the filtered indexes?

0 Answers  

I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 Answers   HCL,

What is a Lock and let me know Different types of locks?

2 Answers  

What are the difference between primary key and unique key? : sql server database administration

0 Answers  

What is the difference between SQL notification and SQL invalidation?

0 Answers   MindCracker,

What are four major operators that can be used to combine conditions on a where clause?

0 Answers  

How do we get month name in SQL Server 2000, Oracle, MS Access?

11 Answers  

What is difference between order by and group by?

0 Answers  

between cast and convert which function would you prefer and why?

0 Answers  

What is self join in sql server joins?

0 Answers