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

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

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

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

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