MS SQL

Spaltenanzahl einer Datenbanktabelle auslesen:

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