RE: retrieving list of tables in a databse

2001-02-23 Thread Philip Arnold - ASP
> Is there a way to recieve a list of table in a specified Database? > > know I rememeber reading something about this a while back but cannot > recall. Which database server? In SQL Server Select distinct Table_Name from Information_Schema.Columns Philip Arnold Director Certified ColdFusion

RE: retrieving list of tables in a databse

2001-02-23 Thread John Stanley
Select * from Information_schema.tables -Original Message- From: Chris Alvarado [mailto:[EMAIL PROTECTED]] Sent: Friday, February 23, 2001 11:45 AM To: CF-Talk Subject: retrieving list of tables in a databse Is there a way to recieve a list of table in a specified Database? know I

retrieving list of tables in a databse

2001-02-23 Thread Chris Alvarado
Is there a way to recieve a list of table in a specified Database? know I rememeber reading something about this a while back but cannot recall. Thanks, -chris.alvarado [developer] - VerticalNet This message is int