a table only if it contains a column called "htmlemail". How can I query
the database and determine if a table has such a column?
I have worked out I can get a list of the tables using SELECT name FROM
sysobjects WHERE Xtype='u' Is there a similar way I can loop through the
list of tables and determine if it includes the column "htmlemail"?
Oh yea, I'm using CFMX6.1 and the database is MS SQL2000, just in case it
makes any difference.
Cheers
Mike Kear
Windsor, NSW, Australia
AFP Webworks
http://afpwebworks.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
