Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
|
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 7th, 2006, 05:51 AM
Registered User
 
Join Date: Aug 2006
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default how to get all the tables from a database

how to get all the tables from a database

Rakesh.G.V
Inetfarme Technologys,
732, 7th Cross, 11th Main Road,
BTM 2nd Stage
Bangalore 560 076, India
 
Phone :
+91-80-26787788
+91-80-26783615
 
Mobile:
9886322550

 http://www.inetframe.com
 
Old August 7th, 2006, 06:39 AM
Authorized User
 
Join Date: Apr 2006
Posts: 79
Thanks: 1
Thanked 0 Times in 0 Posts
Send a message via AIM to anujrathi Send a message via MSN to anujrathi Send a message via Yahoo to anujrathi
Default

Hi Rakesh,
I can give u the solution but first of all, can u clear ur question ?
Wht u want ? From Which database do u want ?
U want to see all the tables present in any perticular database or u want to import them in dataset ? Pls always post full information !!!!

Regards,
Anuj Rathi
 
Old August 8th, 2006, 01:35 AM
Registered User
 
Join Date: Aug 2006
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

how to get all the tables from a single database(any database).Means i want to just get information of all the tables from a single database.

Rakesh.G.V
Inetfarme Technologys,
732, 7th Cross, 11th Main Road,
BTM 2nd Stage
Bangalore 560 076, India
 
Phone :
+91-80-26787788
+91-80-26783615
 
Mobile:
9886322550

 http://www.inetframe.com
 
Old December 1st, 2006, 03:19 AM
Registered User
 
Join Date: Dec 2006
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

hi try this statement
select *from inoformation_schema.tables
to get the tables information in current database

Thanks,
Prabhakaran
 
Old December 1st, 2006, 08:33 AM
Friend of Wrox
 
Join Date: Oct 2006
Posts: 475
Thanks: 0
Thanked 9 Times in 9 Posts
Default

Go to Enterprise Manager... right click on a table, select generate scripts, follow your nose.

--Jeff Moden





Similar Threads
Thread Thread Starter Forum Replies Last Post
Where r database tables get stored ?? kajal SQL Server 2005 1 April 1st, 2007 08:38 AM
sending tables to another database howardrsh BOOK: Beginning Access VBA 1 October 5th, 2006 06:49 PM
Multiple database tables akibaMaila VB.NET 2002/2003 Basics 0 September 27th, 2005 11:19 AM
Populating database tables mespejo Beginning PHP 9 November 30th, 2004 11:02 AM
load tables into database kobystud C# 4 July 20th, 2004 12:31 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.