Excellent! Does anybody have an Oracle equivalent?
> -----Original Message-----
> From: Eric Creese [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 04, 2003 2:20 PM
> To: CF-Talk
> Subject: GET TABLES IN DATASOURCE / GET FIELDS IN TABLE
>
>
> SELECT sysobjects.id as tableid,sysobjects.name as tablename,
> syscolumns.name as columnname
> FROM sysobjects, syscolumns
> WHERE sysobjects.type = 'U'
> AND sysobjects.id = syscolumns.id
> ORDER by sysobjects.id
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
