did you get the mail??? ----- Original Message ----- From: "Snake Hollywood" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 10, 2003 12:15 PM Subject: RE: [ cf-dev ] Database schema tool
> Yes I know that, I'm not so lazy I can't write a one line query, but as > I stated, I need all the column info for the tables as well. > > > -----Original Message----- > > From: Robertson-Ravo, Neil (RX) > > [mailto:[EMAIL PROTECTED] > > Sent: 10 October 2003 11:49 > > To: '[EMAIL PROTECTED]' > > Subject: RE: [ cf-dev ] Database schema tool > > > > > > 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] > > > > > -- > ** 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]
