hi, Is there any method to get field constraints i.e primary key,foriegn key etc from Ms-Sql 7?
http://www.php.net/manual/en/ref.mssql.php
This might be handy... mssql_fetch_field -- Get field information ...would probably tell you if it was a key
Mr.Van i had tried to figur out from the mssql library but useless. Any other idea?
Unfortunately, I've never had the pleasure of working with MSSQL, so I really wouldn't know how to help you on that one... but field functions are usually the way to retrieve the description of a fields properties.
Yeah mssql_fetch_field dosen't has any such proerpty through which i can get constraints.
