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 the contrast between sql and pl/sql?

0 Answers  

What is the beast way to write CTE in SQL Server ?

0 Answers   HCL,

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

0 Answers  

Define DML and DCL statements?

1 Answers   Hexaware, NIIT,

How to create an index on a view?

0 Answers  

can any one please send sql quries most used in applications.

2 Answers  

What is an index. What are the types?

0 Answers  

What is the use of partition by in sql server?

0 Answers  

How to find which stored procedure is currently running in sql server?

0 Answers  

What is RAID and what are different types of RAID configurations?

8 Answers   Wipro,

What is meant by Active-Passive and Active-Active clustering setup?

0 Answers  

What is stretch database in sql server?

0 Answers