Yeah I hosed that up didn't I. I was umm tired yeah tired, and stuff. Tim Heald ACP/CCFD :) Application Development www.schoollink.net
> -----Original Message----- > From: Costas Piliotis [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 26, 2002 1:07 PM > To: CF-Talk > Subject: RE: Get list of tables from a SQL Server DB > > > Uh... Isn't it: > > select [name] from sysobjects where xtype = 'U' > > -----Original Message----- > From: Tim Heald [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 25, 2002 9:58 PM > To: CF-Talk > Subject: RE: Get list of tables from a SQL Server DB > > > <CFQUERY name="getTables" datasource="#dsdata#"> > Select name > >From systables > Where xType = u > </CFQUERY> > > <CFSET tableList= valueList(getTables.name)> > > Tim Heald > ACP/CCFD > Application Development > www.schoollink.net > > -----Original Message----- > From: Vishal Narayan [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 26, 2002 12:42 AM > To: CF-Talk > Subject: Get list of tables from a SQL Server DB > > > Is there any way I can get the list of tables in a SQL 2000 DB > programmatically ? I guess what I need is a limited form of > sp_help, as long > as it just gives me all the user-created tables, system tables > not required. > > Vishal. > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
