SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema=MyDatabase AND table_name = MyTable
SELECT COUNT(COLUMN_NAME) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG = 'database' AND TABLE_SCHEMA = 'dbo' AND TABLE_NAME = 'table'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)