How can display all table name in a Database ?

Question

Anonymous User · Answer

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.Tablesand 2). SELECT*FROM information_schema.tables3). sp_tables '%cust%'and  and  and  and  and  and  and --------(search table)4). SELECT * FROM sys.Tables WHERE name LIKE '%cus%'5). SELECT * FROM information_schema.tables WHERE table_name  LIKE '%cust%'

forum

How can display all table name in a Database ?

Anonymous User

Can you answer this question?

1 Answers

Liked By