select * from sysobjects WHERE xtype='u' OR SELECT * FROM Sys.tables

use
select * from tab;

to see all the tables stored in the database.

Hello ,

Use the

select * from table_name;

to see full contents of the table.

Hi

By using this query u can get all tables.

SELECT TABLE_NAME  FROM INFORMATION_SCHEMA.TABLES

If you are using SQL Server 2005 or 2008 there are new system views available in INFORMATION_SCHEMA. To retrieve all the tables: SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' The INFORMATION_SCHEMA views offer a lot more great database searching options. Check out the other query options here: http://msdn.microsoft.com/en-us/library/ms186778.aspx

In sql server

Select * from sysobjects where type='U'

In Oracle

Select * from USER_TABLES

USE databaseName
GO
SELECT * FROM sys.Tables
GO