I wish to (in PHP) dynamically retrieve a list of acceptable/available values for a column in a MSSQL database, for a field which has a Check Constraint to try to get functionality similar to MySQL ENUM data type.
Is there an easier way to do this? with MySQL it's apparently quite simple (see code). MSSQL has a string for the Check Constraints and takes a lot of effort to get to in the schema.
from the site http://dev.mysql.com/doc/refman/5.0/en/enum.html :
This is an extremely simple way to get the options from an enum into an array, here called $arryEnum
$result=mysql_query("SHOW COLUMNS FROM <table> LIKE '<column>'");
if( mysql_num_rows( $result ) > 0 )
preg_match_all("/'(.*?)'/", $row['Type'], $matches);
The important bit is the regexp, which just matches anything in apostrophes.