Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old August 7th, 2006, 05:51 AM
Registered User
 
Join Date: Aug 2006
Location: Bangalore, Karnataka, India.
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
Reply With Quote
  #2 (permalink)  
Old August 7th, 2006, 06:39 AM
Authorized User
Points: 375, Level: 6
Points: 375, Level: 6 Points: 375, Level: 6 Points: 375, Level: 6
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2006
Location: New Delhi,India.
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
Reply With Quote
  #3 (permalink)  
Old August 8th, 2006, 01:35 AM
Registered User
 
Join Date: Aug 2006
Location: Bangalore, Karnataka, India.
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
Reply With Quote
  #4 (permalink)  
Old December 1st, 2006, 03:19 AM
Registered User
 
Join Date: Dec 2006
Location: Bhopal, MP, India.
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
Reply With Quote
  #5 (permalink)  
Old December 1st, 2006, 08:33 AM
Friend of Wrox
Points: 1,536, Level: 15
Points: 1,536, Level: 15 Points: 1,536, Level: 15 Points: 1,536, Level: 15
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2006
Location: , MI, USA.
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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 09:27 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.