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.

Explain raiserror in sql server?

0 Answers  

What are the basic functions for master, msdb, model, tempdb and resource databases?

0 Answers  

What are user-defined functions (udfs) in sql server?

0 Answers  

Can we passed multiple recordset(set of records) using a Stored Procedure

2 Answers  

Explain the new features of SQL server 2000?

1 Answers  

What is read committed?

0 Answers  

Explain the properties of a relational table?

0 Answers  

what are constraints? : Sql server database administration

0 Answers  

What are triggers? How do you invoke a trigger on demand?

0 Answers   Hexaware,

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

0 Answers  

If we delete pack Spec what will be the status of pack Body ?

0 Answers   Nagarro,

What will be query used to get the list of triggers in a database?

0 Answers