http://www.sqlzoo.net/howto/source/z.dir/i12meta.xml Check out the META DATA section of this page (link above). I used it to create a database 'walker' app that lets you search for table names, column names, etc. I was working on a HUGE database that wasn't documented well and nobody could give me good answers on how things joined..haha. so this meta data was very helpful. It's basically stored in a table in SQL Server, all the table/column information. So it's super simple to get the information you want. Check out this query: SELECT * FROM sysobjects good luck! -TG = = = Original message = = = Is there a way to programatically get information about a specific table and/or field? And also any constraints that a field has? thnx, Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php ___________________________________________________________ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
