Find No. of Columns in a table

Posted by Saranya Boopathi under Sql Server category on 6/11/2013 | Points: 40 | Views : 1704

select count(COLUMN_NAME)  from INFORMATION_SCHEMA .COLUMNS where TABLE_NAME ='Login'

Bookmark It

Latest Code Snipptes