Chris Boget wrote:
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
sp_help @objname='{tablename}'
This will actually return several recordsets which are probably
available individually in the other
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 gi
Look into the INFORMATION SCHEMA views in SQL Books Online for a
starting point.
Mark
-Original Message-
From: Chris Boget [mailto:[EMAIL PROTECTED]
Sent: 22 April 2005 15:51
To: PHP General
Subject: [PHP] MSSqlServer table/field information
Is there a way to programatically get
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
> Look into the INFORMATION SCHEMA views in SQL Books Online for a
> starting point.
Excellent tip! Thanks. With the help provided by everyone who
replied, I came up with the following:
Query to get the primary key(s) for a table
sp_pkeys @table_name=''
Query to get the column names for a t
5 matches
Mail list logo
