Query to Find number of Columns in a table

Posted by Kirthiga under Sql Server category on 5/27/2013 | Points: 40 | Views : 1212

select COUNT(COLUMN_NAME) [NoOfColumns] from INFORMATION_SCHEMA.COLUMNS where Table_Name= 'TableName'

Bookmark It

Latest Code Snipptes