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:

Technical Roadmap Planning: A Comprehensive Guide for US Business Leaders

Technical Roadmap Planning Introduction to Technical Roadmap Planning Technical roadmap planning is a strategic process used by orga...