ATAGINFO() ? John Weller 01380 723235 07976 393631
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Derek Kalweit > Sent: 25 April 2007 15:53 > To: [EMAIL PROTECTED] > Subject: MSSQL database creation/modification/maintenance > scripting/functions? > > > Hello. I'm sure I'm not the first to have the need for it-- I need a > way to detect the current database setup(tables, fields, indexes) and > alter the MSSQL database appropriately based on the current state. I > have a small VBS script written that can do this for tables and fields > using INFORMATION_SCHEMA.TABLES and INFORMATION_SCHEMA.COLUMNS, but I > can't find an easy way to do the same for indexes. I use an XML file > for my database definition. > > Is there a better way? Some way to easily get the index information > and create/modify them as needed? I'm sure I could probably use the > sys tables in the master database, but I was hoping there might be > something easier-- an API even... Anything MSSQL, VFP, VBS, T-SQL, > .NET, etc. could be a good solution. > > Any comments/suggestions? Thanks. > > _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
