Thursday, 10 May 2012

Count No. of columns in Table

USE [TESTDB]

SELECT COUNT(*)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'DetailMaster'

No comments:

Post a comment