Loading
How to find All tables of the data base.
7 Answers
select * from sysobjects WHERE xtype='u'
OR
SELECT * FROM Sys.tables
Shiv kumarPosted Apr 21, 2014, 8:12 AM
use
select * from tab;
to see all the tables stored in the database.
select * from tab;
to see all the tables stored in the database.
kanchan setiaPosted Jan 31, 2011, 12:58 AM
Hello ,
Use the
select * from table_name;
to see full contents of the table.
Himanshu DubeyPosted May 5, 2009, 9:02 AM
Hi
By using this query u can get all tables.
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
Blocked AccountPosted Apr 7, 2009, 7:05 AM
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
Nathan AndersonPosted Apr 6, 2009, 12:24 PM
In sql server
Select * from sysobjects where type='U'
In Oracle
Select * from USER_TABLES
Bharat JoshiPosted Apr 6, 2009, 2:46 AM
USE
databaseNameGO
SELECT * FROM sys.Tables
GO
Purushottam RathorePosted Apr 3, 2009, 2:13 AM