Do you know where your variables are? | |
PerlMonks |
Re: Database Table Namesby bilfurd (Hermit) |
on Nov 07, 2003 at 22:10 UTC ( [id://305468]=note: print w/replies, xml ) | Need Help?? |
DBI & ODBC are very handy when dealing with SQL Server (I use it whenever possible), but in the spirit of TMTOWTDI --
In the database, there is a table called sysobjects that stores information about all the objects in that database. Each object type (key, table, index, etc.) has a specific code. These codes are stored in the xtype field. So...
... should return a list of all table names in the database. Cheers
In Section
Seekers of Perl Wisdom
|
|