?
Solved

What SQL command = Oracle's "SELECT * FROM TAB"

Posted on 2004-10-06
3
Medium Priority
?
2,646 Views
Last Modified: 2012-06-21
I'm looking for a command that will return a dataset of all the tables in a DB.  Oracle syntax is "SELECT * FROM TAB".

Thanks
0
Comment
Question by:natejacobs
  • 2
3 Comments
 
LVL 6

Expert Comment

by:izblank
ID: 12238646
how about
select * from systables

0
 
LVL 18

Accepted Solution

by:
ShogunWade earned 500 total points
ID: 12238649
SELECT * FROM INFORMATION_SCHEMA.TABLES
0
 
LVL 18

Expert Comment

by:ShogunWade
ID: 12238657
there is no such object as systables in sql server
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question