I have a SQL Server 2012 database called MyDatabase. How can I find how many tables are in the database?
I'm assuming the format of the query would be something like the following, but I don't know what to replace database_tables with:
USE MyDatabase
SELECT COUNT(*)
FROM [database_tables]