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.

How to encrypt Strored Procedure in SQL SERVER?

0 Answers  

What are the properties of sub-query?

0 Answers  

What languages bi uses to achieve the goal?

0 Answers  

Can you link only other SQL Servers or any database servers such as Oracle?

1 Answers  

What are the authentication modes in sql server? How can it be changed?

0 Answers  

Rate yourself in .NET and SQL ?

1 Answers   Cognizant, HCL, SunGard,

What are the properties of primary key?

0 Answers  

What do you understand by user-defined function in the sql server?

0 Answers  

Which command executes the contents of a specified file?

2 Answers   ABC, InfoMedia,

Can a database be shrunk with users active?

0 Answers  

Explain the architecture of SQL Server?

2 Answers   ABC, HP, Oracle,

Differentiate between a primary key and a unique key.

0 Answers