Hi,
I want to know that "how many tables are active in my database" by a single query in SQL server.
How can display all table name in a Database ?
Ask by Anonymous User
Updated 21 Sep 2018
Hi,
Rahul Ji,
I am giving you some database query, I hope that it will help you.
These are my database and table.
Display All Table name in a Data Base at a time.
1). SELECT* FROM sys.Tables
2). SELECT*FROM information_schema.tables
3). sp_tables '%cust%' --------(search table)
4). SELECT * FROM sys.Tables WHERE name LIKE '%cus%'
5). SELECT * FROM information_schema.tables WHERE table_name LIKE '%cust%'