Member Avatar for deolalkar_pooja

Hi to all,
I created the following table
---------------------------------

create table publisher(name varchar(20), city varchar(20))

---------------------------------

I want to put following constraint, 'name is having unique with city taken only from 'mumbai', 'pune', 'nasik', 'panji''. I know about unique constraints with name. I searched many about constraint with city, but i don't get it till now. Will you please help me about constraint. I used 'BETWEEN' constraint, but it failed. What should I do?

  • 2 Contributors
  • 7 Replies
  • 95 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by smantscheff
Member Avatar for smantscheff

If the field may only have four values, use an enum type.

create table publisher(name varchar(20), city enum('mumbai','pune','nasik','panji'))
Member Avatar for deolalkar_pooja

hi......smantscheff.
i tried on ur solution, but it doesn't work. Plz, help me in different way.

Member Avatar for smantscheff

What the hell do you mean with "doesn't work" ?

Member Avatar for deolalkar_pooja

i means, sql server doent't support 'enum' type.

Member Avatar for smantscheff

This here is a MySQL forum.

Member Avatar for deolalkar_pooja

I know, this is mysql forum. I wrongly put this question in this forum. but i want the output in 'MS SQL Server'.


Thanks & regerds,
Pooja.

Member Avatar for smantscheff

Create a lookup table for cities and link your publisher table to it.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.