Thursday, 27 June 2013

Count the number of columns of a table

SELECT count(*)
FROM information_schema.columns
WHERE table_name = 'SIS_STUDENT_MST'

No comments:

Post a Comment