Cool, thanks for the tip, I'll look into it. ~Steve http://lanctr.com/
-----Original Message----- From: Web Specialist [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 4:30 PM To: CF-Talk Subject: Re: OT: Printing Database Structure Cool. Anyway I'll suggest you to know about DataMgr. DataMgr do this job so easy. http://datamgr.riaforge.org/ With getDatabaseTables method and looping over calling getDBTableStruct method. Cheers Marco Antonio On Fri, Apr 25, 2008 at 6:19 PM, Steve Good <[EMAIL PROTECTED]> wrote: > Yep, that did the trick. You rock! > > This time I saved the query ;) > > ~Steve > http://lanctr.com/ > > > -----Original Message----- > From: Web Specialist [mailto:[EMAIL PROTECTED] > Sent: Friday, April 25, 2008 4:13 PM > To: CF-Talk > Subject: Re: OT: Printing Database Structure > > Do you can try this statement: > > SELECT TABLE_CATALOG, > TABLE_NAME,COLUMN_NAME, > DATA_TYPE, > CHARACTER_MAXIMUM_LENGTH, > NUMERIC_PRECISION, > NUMERIC_SCALE, > IS_NULLABLE, > COLUMNPROPERTY(OBJECT_ID(TABLE_NAME), COLUMN_NAME, 'IsIdentity') AS > IS_AUTOINCREMENT, > COLUMN_DEFAULT > FROM INFORMATION_SCHEMA.COLUMNS > ORDER BY 2,3 > > Cheers > Marco Antonio > On Fri, Apr 25, 2008 at 5:43 PM, Steve Good <[EMAIL PROTECTED]> wrote: > > > I did this once before, but forgot how I did it, and can't figure out how > I > > found the answer either. > > > > > > > > Do any of you know how I can print all the table names, columns in the > > tables, and data types of the columns from within MS SQL Server Mgmnt > > Studio? > > > > > > > > Thanks. > > > > > > > > ~Steve > > > > http://lanctr.com/ > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304275 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
