> Is the owner the same for all the tables?
Yeah, user permissions on the account that's logging in to that DSN
would be my guess too.
> SELECT * FROM INFORMATION_SCHEMA.TABLES
Yep... information_schema is apparently an actual standard... problem is
most people don't know about it because you have to fork over $200 or
somesuch to see the specs for it. Which is probably why more developers
aren't aware of it and also probably why more db's don't support it,
because the developers don't know about it. Or at least that's what I
found in my research, though I could be wrong or out-dated.
Anyway, yeah, since SQL Server supports it, you can get your db info
that way too, provided you're not too worried about switching platforms.
--
s. isaac dealey ^ new epoch
isn't it time for a change?
ph: 503.236.3691
http://onTap.riaforge.org/blog
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296480
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
