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.

I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.

7 Answers  

What is the difference between the application object and session object?

0 Answers  

How to check if a table is being used in sql server?

0 Answers  

Explain what is lock escalation?

0 Answers  

Explain what are the basic functions for master, msdb, model, tempdb databases?

0 Answers  

What do you think of this implementation? Can this be implemented better?

0 Answers  

Do you know spatial data types - geometry and geography in sql server 2008?

0 Answers  

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

0 Answers  

How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

5 Answers   Infosys, McAfee,

syntex of insert

7 Answers  

how do u find least salary in a table

4 Answers  

in the physical file layout, where should the transaction log be stored in relation to the data file?

0 Answers