Re: How can i get all the table names from a databse ?

From: Arild Bakken (arildb__at_hotmail.com)
Date: 05/28/04 

Date: Fri, 28 May 2004 08:42:24 +0200

For MSSQL:

  select name from sysobjects where type = 'U'
or
  select table_name from information_schema.tables where table_type = 'BASE
TABLE'

For other RDBMS - check their documentation.

Arild

"¹ùÑÇ·æ" <green_hand_2000@yahoo.com> wrote in message
news:eNCwiGFREHA.3988@tk2msftngp13.phx.gbl...
> in my app, i need to fetch all the table names in a database ,which SQL
> statements i can use ?
>
> Thanks for any advices !
>
> Albert Guo
> Jiangsu ,China PRC
> ---------------------------------------------
>
>

Relevant Pages

  • Re: Python for large projects
    ... >> The ability to do unit testing should not be an afterthought. ... > look into a queue, and if there is a new URL to fetch, fetches it with ... All of the interfaces to the job management object and the job object need to be ... interface documentation and one writing test scaffolding against the same ...
    (comp.lang.python)
  • Re: getting a minimize button in dialog based apps to work
    ... header aygshell.h (found via documentation for SHINITDIALOG struct), ... the cancel button flag was not recognized. ... Here's what I found in the header... ... This is a MFC app, but I don't see why that would have any impact on the ...
    (microsoft.public.pocketpc.developer)
  • Re: Where to put info about apps in OS X?
    ... the decoded app itself goes in "Applications" at sysadmin level. ... I have a folder called "Information" which I created inside my Documents ... documentation together, and put that folder in Applications. ...
    (comp.sys.mac.apps)
  • Re: CeRunAppAtEvent problem
    ... Your app is already running, so it is brought to the ... The API documentation states: ... The command line, ... can be one of the following string constants. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: URGENT: SetParent: Using external process as child window of calling process?!
    ... The documentation is, as you point out, quite ... But I wouldn't trust SetParent for anything. ... You have to create the second app as an OLE Server app, and use your app as an OLE client. ... Determining the main window of the process after the message queue is ...
    (microsoft.public.vc.mfc)