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.

Tell me what is a linked server?

0 Answers  

When you first load SQL SERVER you will startup with what all databases?

3 Answers   CompuSol,

What is not null constraint?

0 Answers  

There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"

2 Answers  

What are the instances when triggers are appropriate?

0 Answers  

What do you do in data exploration

0 Answers   EXL,

What is logshipping and its purpose?

0 Answers  

How to provide values to stored procedure parameters in ms sql server?

0 Answers  

How do I find sql server instance name?

0 Answers  

What is @@rowcount in sql?

0 Answers  

How to provide default values to stored procedure parameters?

0 Answers  

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

0 Answers