Posted by tg-php on 04/22/05 18:02

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.

• Next in forum: Re: [PHP] Documentation for VAR
• Prev in forum: Documentation for VAR
• Thread view: Re: [PHP] MSSqlServer table/field information

[Reply to this message]