Solved

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

Posted on 2004-10-06
3
2,614 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 125 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 Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
convert varchar UTC to human datetime 1 38
point in time restore in SQL server 26 41
Many to one in one row 2 35
MS SQL Server Management Studio R2 4 24
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

713 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