Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


how to find number of columns in a table in sql server 2000
and 2005 also

Answers were Sorted based on User's Feedback



how to find number of columns in a table in sql server 2000 and 2005 also..

Answer / kishore

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

In this querry may name is Tablename

Is This Answer Correct ?    58 Yes 23 No

how to find number of columns in a table in sql server 2000 and 2005 also..

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

Is This Answer Correct ?    34 Yes 8 No

how to find number of columns in a table in sql server 2000 and 2005 also..

Answer / sudhir kumar

IN SQLSERVER 20005


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


try in sql server 2000

Is This Answer Correct ?    29 Yes 5 No

how to find number of columns in a table in sql server 2000 and 2005 also..

Answer / bhaskar

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

Is This Answer Correct ?    13 Yes 3 No

how to find number of columns in a table in sql server 2000 and 2005 also..

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

Is This Answer Correct ?    14 Yes 6 No

how to find number of columns in a table in sql server 2000 and 2005 also..

Answer / surbhi

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

Is This Answer Correct ?    8 Yes 1 No

how to find number of columns in a table in sql server 2000 and 2005 also..

Answer / saravanan p

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

Is This Answer Correct ?    8 Yes 4 No

how to find number of columns in a table in sql server 2000 and 2005 also..

Answer / rajkumar v

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

EMP table name

Is This Answer Correct ?    3 Yes 0 No

how to find number of columns in a table in sql server 2000 and 2005 also..

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

Is This Answer Correct ?    6 Yes 4 No

how to find number of columns in a table in sql server 2000 and 2005 also..

Answer / vidit tyagi

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

Is This Answer Correct ?    6 Yes 4 No

Post New Answer



More SQL Server Interview Questions

What is field in algebra?

0 Answers  


Why I am getting this error when dropping a database in ms sql server?

0 Answers  


create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,


if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition

1 Answers   Aviva,


What are the new features in sql server 2016?

0 Answers  






What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,


What Are Three Rules to UseĀ UNION IN SQL SERVER

1 Answers  


How do indexes help, types?

0 Answers  


How we Resize table,temp table, database and log file size in SQL Server 2005

1 Answers   ABC,


How to rebuild indexes with alter index ... Rebuild?

0 Answers  


What are the steps to take to improve performance of a poor performing query? : sql server database administration

0 Answers  


What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

0 Answers  






Categories