Tuesday 25 October 2016

get table count in sql server

SELECT COUNT(*) from information_schema.tables
WHERE table_type = 'base table'

No comments:

Post a Comment