Thursday, February 23, 2017

Count Columns in Table in SQL Server

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

No comments:

Chaos Engineering Principles: A Comprehensive Overview for US Business Leaders

Chaos Engineering Principles Introduction to Chaos Engineering Definition and Purpose Chaos engineering is a discipline within soft...