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

Reply via email to