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:

Platform Engineering Fundamentals: An Informational Guide for US Business Owners

Platform Engineering Fundamentals Introduction to Platform Engineering Platform engineering is an emerging discipline within the tec...