Find No. of Columns in a table

Saranya Boopathi
Posted by Saranya Boopathi under Sql Server category on | Points: 40 | Views : 870
Find No. of Columns in a table
select count(COLUMN_NAME)  from INFORMATION_SCHEMA .COLUMNS where TABLE_NAME ='Login'

Comments or Responses

Login to post response