Get the Table Count in a DB in SQL

Get the table count in a DB in SQL.
  1. select * from sys.tables where is_ms_shipped='0'