> -----Original Message----- > From: Stacy Young [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 29, 2002 4:17 PM > To: CF-Talk > Subject: Standard SQL to get a Table List ? > > Is this specific to each vendor? (accessing system tables > or what not) Anyway to do this with standard SQL ?
Yes, every db or db server has its own internal mechanisms for storing information about its tables, views, etc. In SQL Server, the list of tables for the database can be retrieved either with SELECT * FROM SYSOBJECTS WHERE OBJECTPROPERTY(ID, N'IsUserTable')=1 (this discludes system table from the list and it the way SQL Server generates scripts which manipulate tables in the db), although there's also an easier way to do it using the information_schema views although I don't remember the specifics off the top of my head. In any event, neither of these will work with MS Access, Oracle, MySQL, PostgreSQL, DB2, FoxPro or any other db or db server with the possible acception of Sybase ( just because much of the groundwork for SQL Server was purchased from Sybase many years ago -- it's not true for Access because Access was actually developed in-house by Microsoft, which largely explains why it is so vastly different from SQL Server ). Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
