SQL Server - what is query of display the all tables in SQL server ?

GeekInterview.com > Tech FAQs > SQL Server

Go To First | Previous Question | Next Question

SQL Server | Question 4 of 55

what is query of display the all tables in SQL server ?

Total Answers and Comments: 11

Last Update: October 10, 2007 Asked by:

Sponsored Links

Best Rated Answer

—

Submitted by: Sanjay Rathore

Select * from tab;

this will work in ORACLE

For SQL Server use:

SELECT * FROM sysobjects where xtype ='U'

Above answer was rated as good by the following members:
taals123

Sorting Options

Page 1 of 2

« First

Last »

November 25, 2006 01:02:41

narendra

RE: what is query of display the all tables in SQL ser...

SELECT * FROM TAB:

Is this answer useful? Yes | No

December 01, 2006 05:21:27

Sanjay Rathore

RE: what is query of display the all tables in SQL ser...

Select * from tab;

this will work in ORACLE

For SQL Server use:

SELECT * FROM sysobjects where xtype ='U'

Is this answer useful? Yes | No

1 0

Overall Rating: +1

December 02, 2006 11:04:17

Mark

RE: what is query of display the all tables in SQL ser...

For 2005 it also can be:

Select * from sys.tables

Is this answer useful? Yes | No

December 05, 2006 11:44:01

ualike

Member Since: August 2006 Contribution: 3

RE: what is query of display the all tables in SQL ser...

Thanks

Is this answer useful? Yes | No

January 18, 2007 10:55:57

Ramesh R. Jaiswar

RE: what is query of display the all tables in SQL ser...

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

sp_help

Regards

Is this answer useful? Yes | No

March 09, 2007 09:56:39

Chitra.M

RE: what is query of display the all tables in SQL ser...

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

Is this answer useful? Yes | No

March 17, 2007 23:53:21

purnaprasad

RE: what is query of display the all tables in SQL ser...

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

Is this answer useful? Yes | No

June 25, 2007 03:48:44

raajbir singh

RE: what is query of display the all tables in SQL ser...

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

Is this answer useful? Yes | No

August 24, 2007 12:07:50

mydeen83

Member Since: June 2007 Contribution: 2

RE: what is query of display the all tables in SQL ser...

sp_help --> For display all tables in the database

Is this answer useful? Yes | No

September 27, 2007 14:04:50

#10

Prabhakaran

RE: what is query of display the all tables in SQL ser...

sp_tables (for Microsoft sql server)

select *from tab; ( for sql plus)

Is this answer useful? Yes | No

Page 1 of 2

« First

Last »

Go To Top