narendra

• Nov 25th, 2006

 

SELECT * FROM TAB:

Sanjay Rathore

• Dec 1st, 2006

 

Select * from tab;

this will work in ORACLE

For SQL Server use:

SELECT * FROM sysobjects where xtype ='U'

Mark

• Dec 2nd, 2006

 

For 2005 it also can be:

Select * from sys.tables

ualike

 Profile Answers by ualike 

• Dec 5th, 2006

 

Thanks

Ramesh R. Jaiswar

• Jan 18th, 2007

 

To display all table in sql thorugh  T-Sql  type below given command.

     sp_help

Regards

Chitra.M

• Mar 9th, 2007

 

sp_tables is used in T-SQL for getting all the tables in respective databases

purnaprasad

• Mar 17th, 2007

 

hi all
pl use this to retrive the tables

select * from information_schema.tables & then press F5----to retrive Tables

select * from information_schema.views & then press F5----to retrive Views

raajbir singh

• Jun 25th, 2007

 

See sp_help will list up all the views along with the tables in the database.
The question is to have the table only.
rather this
select * from sysobjects where type like '%u' order by name

Query may help

mydeen83

 Profile Answers by mydeen83 

• Aug 24th, 2007

 

sp_help  --> For display all tables in the database

Prabhakaran

• Sep 27th, 2007

 

sp_tables  (for Microsoft sql server)


select *from tab;   ( for sql plus)

Dheeraj Chakravarthy

• Oct 10th, 2007

 

select * from information_schema.tables

- Dheeraj

santanukd

 Profile Answers by santanukd 

• May 14th, 2009

 

Just replace "[your-schema-name-here]" in the following query with your schema name. Hope it comes handy to some of you out there.

Select OBJECT_TYPE,OBJECT_NAME
FROM
(
Select 'TABLE' as OBJECT_TYPE, TABLE_NAME as OBJECT_NAME, TABLE_SCHEMA as OBJECT_SCHEMA from information_schema.VIEWS
Union
Select 'VIEW' as OBJECT_TYPE, TABLE_NAME as OBJECT_NAME, TABLE_SCHEMA as OBJECT_SCHEMA from information_schema.VIEWS
Union
Select 'INDEX[Type:Name:Table]' as OBJECT_TYPE, concat(CONSTRAINT_TYPE,' : ',CONSTRAINT_NAME,' : ',TABLE_NAME) as OBJECT_NAME,TABLE_SCHEMA AS OBJECT_SCHEMA from information_schema.TABLE_CONSTRAINTS
Union
Select 'Procedure/Functions' as OBJECT_TYPE, ROUTINE_NAME as OBJECT_NAME, ROUTINE_SCHEMA as OBJECT_SCHEMA from information_schema.ROUTINES
) R

Where R.OBJECT_SCHEMA=[your-schema-name-here]

satheyaraaj

 Profile Answers by satheyaraaj 

• Jul 9th, 2011

 

Database Name..Sp_Help

sunshine60india

 Profile Answers by sunshine60india 

• Jul 16th, 2011

 

SELECT * FROM SYS.TABLES

SELECT * FROM SYSOBJECTS WHERE XTYPE = 'U'

SELECT * FROM SYS.OBJECTS WHERE TYPE = 'U'

saikiran

• Jul 22nd, 2011

 

select * from sys.tables

Keer

• Apr 25th, 2012

 

select * from sys.tables where type = U