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

In this querry may name is Tablename

select count (*) from tablename.

@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')

--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

IN SQLSERVER 20005 


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


try in sql server 2000

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.........