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.

Why do we need different type of parameter?

0 Answers  

What are the different ways of moving data/databases between servers and databases in SQL Server?

3 Answers   HCL,

How do you delete a data source?

0 Answers  

How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)

2 Answers  

what is an sql server?

1 Answers  

Explain the properties of sub-query in sql server?

0 Answers  

How to link tables in sql server?

0 Answers  

how many clustered indexes can be created on a table? : Sql server database administration

0 Answers  

Find top Nth employee from each department in terms of salary?

13 Answers   RealPage,

What are the different types of stored procedures?

0 Answers  

What is in place upgrade in sql server?

0 Answers  

How will you optimize a stored procedure optimization?

0 Answers