Hello all. I want to know whether it is possible to retrieve list of all tables found in a particular database titled 'Company'? It have got several tables with the names, Suppliers, Customers, etc etc. Just like Oracle, where you retrive all tables using select * from tab; . Is it possible to do the same in MS SQL???
bnitishpai
0
Newbie Poster
Recommended Answers
Jump to PostIn the mySQL prompt you should be able to type the following and it should show all tables in the database. See the following link for a summary of commands http://www.pantz.org/software/mysql/mysqlcommands.html
Jump to PostThere are a couple of ways to do it, depending on what version of SQL Server you are using and how detailed you need to get. First, in your query tool of choice (usually Management Studio) point to the database you're interested in, then use one of these:
All 5 Replies
RaptorSix
0
Newbie Poster
bnitishpai
0
Newbie Poster
BitBlt
452
Practically a Master Poster
Featured Poster
RaptorSix
0
Newbie Poster
code739
17
Posting Whiz in Training
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.