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 is RMS migrations?

0 Answers   Satyam,

What is the syntax to execute the sys.dm_db_missing_index_details?

0 Answers  

What are the difference between data length and length in SQL Server-2008?

3 Answers   Scio Healthcare,

What is Dedicated Administrator Connection in sql server 2005?

2 Answers  

What is a non-clustered index?

0 Answers  

Distinguish between commit and rollback?

0 Answers  

How to get nth highest salary from employee table.

0 Answers  

What is the use of partition by in sql server?

0 Answers  

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

0 Answers  

how to find maximum identity number in a table ?

2 Answers   JPMorgan Chase, Thomson Reuters, Wipro,

How connect excel to sql server?

0 Answers  

What are xml indexes?

0 Answers