NodeReaper has asked for the wisdom of the Perl Monks concerning the following question:

This node falls below the community's minimum standard of quality and will not be displayed.

Replies are listed 'Best First'.
Re: Names os Tables from a DB.
by EdwardG (Vicar) on Nov 08, 2003 at 13:40 UTC 
    select name
from sysobjects
where xtype = 'U'

    [download]

    For the sake of portability it might also be useful to note that ANSI SQL-92 provides a standard for querying table schema information:

    select TABLE_NAME from INFORMATION_SCHEMA.TABLES

    See also this discussion started by gmax, particularly this node which has more relevant info.

[reply]
[d/l]
[select]
Re: Names os Tables from a DB.
by etcshadow (Priest) on Nov 08, 2003 at 16:44 UTC
    What the heck? The exact same question, posted yesterday, probably by the exact same Anonymous Monk, is still on the first screen of SoPW. And it's been answered 5 times already!

    What the hell are we answering this guy's question for if he is not even reading the replies. And why do we keep approving his re-posts?


    ------------
    :Wq
    Not an editor command: Wq
[reply]
    A reply falls below the community's threshold of quality. You may see it by logging in.

Back to Seekers of Perl Wisdom