ansaurus

Question

Answer 1

+2 A:

In MS-SQL Server 7+:

SELECT count(*)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'mytable'

Ngu Soon Hui 2009-09-23 09:46:55

The information_schema gets populated from the values corresponding to the current database connection so this will work.

Vinko Vrsalovic 2009-09-23 09:53:50

Answer 2

+3 A:

SELECT COUNT(COLUMN_NAME) FROM INFORMATION_SCHEMA.COLUMNS WHERE 
TABLE_CATALOG = 'database' AND TABLE_SCHEMA = 'dbo'
AND TABLE_NAME = 'table'

Vinko Vrsalovic 2009-09-23 09:47:29

Answer 3

+2 A:

This gets the columns name

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = 'YourTableName'

And this one gets the count

SELECT Count(*) FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = 'YourTableName'

Peymankh 2009-09-23 09:49:51

To get total number of columns in a table in sql