yes from the system tables cant think of the exact query off the top of my head.
On 10/22/06, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > > Slightly Off-Topic SQL question: > > Using SQL Server 2000, is there any way to get (a) a list of > non-system table names for a given database, and (b) any way to get > the datatypes for database columns? This would be via two different > queries. > > I want to create a CF-based utility that I can "point" at a DSN, read > the table names, return that list to the user so they can select which > tables to back up; then, those tables that are chosen to be backed up, > I will do the backup much the way MySQL does, by creating an SQL > script that is all insert statements. However, in order to write the > insert statements correctly, I need to know whether to quote the > values being inserted. > > Moreover, it just seemed like a fun project to work on :) > > Thanks, > > Pete > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257678 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
