What is the query used to display all tables names in SQL Server (Query analyzer)?

  • Interview Candidate
  • 12
  • 1976

Showing Answers 1 - 12 of 12 Answers

sheetal rawat

  • Mar 26th, 2007
 

select * from sysobjects

  Was this answer useful?  Yes

Sellapillai N

  • May 21st, 2007
 

select type,name from sysobjects
where type in ('u','s','v')

  Was this answer useful?  Yes

srikanth tirunagari

  • May 25th, 2007
 


select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_TYPE = 'BASE TABLE'

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions