Solved

in MSSQL, how can i retrieve accepted values as list equivalent to MySQL ENUM values? PHP preferred

Posted on 2009-05-13
2
541 Views
Last Modified: 2013-12-12
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
 

<?php

$result=mysql_query("SHOW COLUMNS FROM <table> LIKE '<column>'");

if( mysql_num_rows( $result ) > 0 )

{

   $row=mysql_fetch_row($result);

   preg_match_all("/'(.*?)'/", $row['Type'], $matches);

   $arryEnum= $matches[1];

}

?> 
 

The important bit is the regexp, which just matches anything in apostrophes.

Open in new window

0
Comment
Question by:labops
2 Comments
 
LVL 14

Accepted Solution

by:
racek earned 500 total points
ID: 24377789
0
 
LVL 2

Author Comment

by:labops
ID: 24379202
Nice.   That gets a little closer, I see the check constraint but not the parameters I'd set.  I was able to find the information from joining two information_schema tables.
Is there a better way to go about this from the start?  It sure would be nice to have that ENUM :(
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now