I've written a small app that parses the SQL Server metadata stored procedures. It will display all the relevant data for any SQL Server table, view, or sproc, including indexes, columns and datatypes, and sproc CREATE text.
It also generates lists of columns names in several formats, CFARGUMENT tags, and CFSTOREDPROC/CFPROCPARAM tags for the relevant DB object type. I can set you up with a demo if you'd like... Let me know, J On Mon, 31 Jan 2005 06:58:34 -0500, Adam Haskell <[EMAIL PROTECTED]> wrote: > DESCRIBE is an SQL Plus command, if i recall. You could easily enough > make a stored procedure to do it in MS SQL I suppose though...heck > someone may have already done it. You could just use Neil's SQL > statement he posted and put it into a cursor and output it all nifty > dandy like SQL Plus does, but personally I rather just read it table > format like it is output in query analyzer ;) Oh I also like to use > DBDesigner 4 its nice to use to print off the table info. > > Adam H > > > On Mon, 31 Jan 2005 00:49:00 -0600, Nick Baker <[EMAIL PROTECTED]> wrote: > > MS SQL 2000 > > > > I want to show a table structure, and tried the following > > > > <CFQUERY NAME="ShowTable" DATASOURCE="PartsList"> > > DESCRIBE Pumpparts > > </CFQUERY> > > > > This only throws an error "Could not find stored procedure 'DESCRIBE'." > > > > What am I missing? Or, am I using the wrong thing here? > > > > DESCRIBE table_name > > > > This command provides information about the columns of the table. It shows > > the column names, the type / size and scale (if applicable) and other > > useful information. > > > > Thanks, > > > > Nick > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192315 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
