well... select name from sysobjects where type = 'U'
will give you all user tables.... -----Original Message----- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 10 October 2003 11:48 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Database schema tool I know someone here, possibly Spike, wrote a tag to query the system tables and give back all user tables and column info for a specified database. Anyone got a copy to save me writing it. Russ Michaels Macromedia/Allaire Certified ColdFusion Developer Satachi Internet Development Phone: 0870 787 3610 Tech Support: 0906 9607800 FAX: 0709 2212 636 http://www.satachi.com email general: [EMAIL PROTECTED] email support: [EMAIL PROTECTED] Join our ColdFusion Developer discussion lists. Send an e-mail to [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
