Query to Find number of Columns in a table

Kirthiga
Posted by Kirthiga under Sql Server category on | Points: 40 | Views : 631
select COUNT(COLUMN_NAME) [NoOfColumns] from INFORMATION_SCHEMA.COLUMNS where Table_Name= 'TableName'

Comments or Responses

Login to post response