> 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
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
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
3 matches
Mail list logo