New topic: Viewing Database/Table Properties Through ODBC
<http://forums.realsoftware.com/viewtopic.php?t=38307> Page 1 of 1 [ 4 posts ] Previous topic | Next topic Author Message softbase Post subject: Viewing Database/Table Properties Through ODBCPosted: Thu Mar 24, 2011 6:37 pm Joined: Mon Jul 02, 2007 11:25 pm Posts: 43 Location: Liberty Lake, WA In a past life, I did a lot of VB programming using ADO. From time to time I would need to check various properties of a database, a table, or a field. No problem. It was fairly easy. But, now that I'm using RB and ODBC to talk to these same databases, I'm not quite sure how to view these same kind of properties. For example, I have a table that I need to see what the exact name of the Primary Key is so that I can programmatically DROP it from the table. How would one go about doing this kind of inquiry of the table properties? Thanks in advance! PS These are MS SQL Server (7.0, 2000, 2005, & 2008) databases. I have around 115 companies using our software with a total of around 2000 users. There is no practical way of manually altering our customers databases by hand. It has to be programmatically done. _________________ Mac Book Pro 8GB Ram RB 2010 R5 Enterprise Edition on Mac OS X Snow Leopard 10.6.5 Top swort Post subject: Re: Viewing Database/Table Properties Through ODBCPosted: Thu Mar 24, 2011 9:27 pm Joined: Mon May 31, 2010 5:35 am Posts: 840 softbase wrote:In a past life, I did a lot of VB programming using ADO. From time to time I would need to check various properties of a database, a table, or a field. No problem. It was fairly easy. But, now that I'm using RB and ODBC to talk to these same databases, I'm not quite sure how to view these same kind of properties. For example, I have a table that I need to see what the exact name of the Primary Key is so that I can programmatically DROP it from the table. How would one go about doing this kind of inquiry of the table properties? Thanks in advance! PS These are MS SQL Server (7.0, 2000, 2005, & 2008) databases. I have around 115 companies using our software with a total of around 2000 users. There is no practical way of manually altering our customers databases by hand. It has to be programmatically done. dont know, but i know there is a new plugin for MS SQL db maybe that can help you out. _________________ SWORTâ¢, it stands for Secure Web Object Realtime Transfer⢠- Windows Vista AND Linux Ubuntu 10.04 LTS - REAL Studio Enterprise(latest) and WEB Edition(latest) - REAL SQL Server 2009 For Dutch User Groups ask me to enter! Top softbase Post subject: Re: Viewing Database/Table Properties Through ODBCPosted: Thu Mar 24, 2011 9:45 pm Joined: Mon Jul 02, 2007 11:25 pm Posts: 43 Location: Liberty Lake, WA swort wrote:dont know, but i know there is a new plugin for MS SQL db maybe that can help you out. But, this plug in is only for windows. I need Cross Platform, hence switching to Real.Studio. _________________ Mac Book Pro 8GB Ram RB 2010 R5 Enterprise Edition on Mac OS X Snow Leopard 10.6.5 Top timhare Post subject: Re: Viewing Database/Table Properties Through ODBCPosted: Thu Mar 24, 2011 10:17 pm Joined: Fri Jan 06, 2006 3:21 pm Posts: 9547 Location: Portland, OR USA Have you tried TableSchema? If that doesn't give you what you want, you can look up info in the MS SQL sys tables. Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 4 posts ]
-- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
