You would be better off using the sp_tables Sproc.....
Justin [EMAIL PROTECTED]
>-----Original Message-----
>From: Dave Hannum [mailto:[EMAIL PROTECTED]]
>Sent: Monday, February 12, 2001 12:00 PM
>To: CF-Talk
>Subject: Re: SQL to find tables
>
>
>Thanks . . .
>
>
>
>
>----- Original Message -----
>From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Monday, February 12, 2001 6:44 AM
>Subject: RE: SQL to find tables
>
>
>> Is there an SQL command I can use to look into a database and dynamically
>> return all of the table names and output them to a page?
>
>Use either Information_Schema.Columns or SysObjects
>
>Select distinct Table_Name
>from Information_Schema.Columns
>order by Table_Name
>
>Select name
>from SysObjects
>where xType='U'
>
>I wouldn't recommend using SysObjects too often as knowing M$, they'll
>change how it works...
>
>Also, these return the system tables as well as the generated tables
>
>Philip Arnold
>Director
>Certified ColdFusion Developer
>ASP Multimedia Limited
>T: +44 (0)20 8680 1133
>
>"Websites for the real world"
>
>**********************************************************************
>This email and any files transmitted with it are confidential and
>intended solely for the use of the individual or entity to whom they
>are addressed. If you have received this email in error please notify
>the system manager.
>**********************************************************************
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
