Hi,
I want to know that "how many tables are active in my database" by a single query in SQL server.
Home / DeveloperSection / Forums / How can display all table name in a Database ?
Hi,
I want to know that "how many tables are active in my database" by a single query in SQL server.
Anonymous User
21-Sep-2018Hi,
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%'