Answer / kishore

select count(*) NoOfColumns from SYSCOLUMNS
WHERE id= (Select id from SYSOBJECTS where name = 'city')

In this querry may name is Tablename

Answer / dharmendra k. dixit

@Anshul..
Bro..through your code u can obtain the Total numbers of
rows in your Table.
---------------------------------

For getting Total Columns i will use this:

SELECT Count(*)As Coloumns
FROM Sys.SysColumns
Where ID =
(SELECT ID FROM Sys.SysObjects Where Name = 'YourTableName')

Answer / sudhir kumar

IN SQLSERVER 20005


SELECT COUNT(COLUMN_NAME) FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'TABLENAME'


try in sql server 2000

Answer / bhaskar

select count(*) from syscolumns where id=(select id from
Sysobjects where [name]='Table_Name')

Answer / anand k

--Count of Columns
SELECT COUNT(*) NO_OF_COLUMNS
FROM SYS.COLUMNS
WHERE OBJECT_ID = OBJECT_ID('<TableName>')
ORDER BY Column_ID

--Column Names
SELECT [NAME]
FROM SYS.COLUMNS
WHERE OBJECT_ID = OBJECT_ID('<TableName>')
ORDER BY Column_ID

Answer / surbhi

SELECT count(*) FROM INFORMATION_SCHEMA.COLUMNS where
table_name='tablename'

Answer / saravanan p

select count(column_Name) from information_schema.columns
where table_name='tableName'

Answer / rajkumar v

select count(*) from information_schema.columns where
table_name='Emp'

EMP table name

Answer / mohan

None of the above answer can result the columns which is
having auto incremented (Identity).
Also if a column is binded to user defined data type that
is also excluded....
So the Correct Number of column cannot be resulted in the
above answers.........

Answer / vidit tyagi

SELECT Count(*)As Coloumns
FROM SysColumns
Where ID =
(SELECT ID FROM SysObjects Where Name = 'TableName')

How self join is different from outer join?

0 Answers   Blue Star,

How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?

2 Answers  

Explain the microsoft sql server delete command? : SQL Server Architecture

0 Answers  

Explain about merge replications?

0 Answers  

What is the difference between varchar and varchar(max) datatypes?

0 Answers  

How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005

1 Answers  

Do you know what are acid properties?

0 Answers  

What about UPDATESTATISTICS ?

2 Answers   HCL, Intelligroup,

How many types of Outer Joins?What are they?

1 Answers  

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

0 Answers  

What is the difference between IN and EXISTS operators in SQL Server?

9 Answers   ASD Lab, CSC, Intelligroup,

Is the primary key column of a table an index in ms sql server?

0 Answers