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 how many normalization forms?

0 Answers  

Why should we go for stored procedures? Why not direct queries?

0 Answers  

How to reaname table name without using sp_Rename in sql server..?

0 Answers   Wipro,

Where do we generally create INDEX?

1 Answers   Ernst Young, Thomson Reuters,

What is index fragmentation in ms sql server?

0 Answers  

Does partitioning help performance?

0 Answers  

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

0 Answers  

What are constraints in microsoft sql server?

0 Answers  

what is the diffrence between Snap Shot and Transaction Replication

2 Answers   CSC,

In what sequence sql statement is processed?

0 Answers  

What is oltp (online transaction processing)?

0 Answers  

Questions on identity?

2 Answers   Infosys,