Thanks, Sam. That looks promising, but there are still a few holes left to fill.
I still don't have the sysproperties.value (MS_Description) which is the column description editable in SQL Enterprise Manager table design view. You script them like this: exec sp_addextendedproperty N'MS_Description', N'Description', N'user', N'dbo', N'table', N'mortgage', N'column', N'description' Also, sp_fkeys doesn't do what I had expected. It will tell me what OTHER tables have foreign keys pointing to my primary key, but it won't tell me what columns in my table ARE a foreign key pointing to another table. I had to use the sysforeignkeys table to get this the old way. Suggestions? ~Brad -----Original Message----- From: Sam Farmer [mailto:[EMAIL PROTECTED] Sent: Friday, January 26, 2007 3:52 PM To: CF-Talk Subject: Re: dynamic form in SQL Server Brad, Here is a system stored proc for getting columns: <cfstoredproc procedure="sp_columns" datasource="#variables.dsn#"> <cfprocparam type="In" cfsqltype="CF_SQL_CHAR" value="#arguments.table#" null="No"> <cfprocresult name="getColSP"> </cfstoredproc> sp_tables gets tables, sp_pkeys gets primary keys. HTH, ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267805 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
