Service Desk Practitioners Forum
cancel

countires database table

Highlighted
Elias Abboud
Acclaimed Contributor.

countires database table

Hi everyone,

SD 4.5 on windows.

In which database table are the countries stored?

Thanks in advance
If you can't solve it, post it :)
5 REPLIES
Ruth Porter
Acclaimed Contributor.

Re: countires database table

Hi there,

Do you mean Time Zones? They are in REP_TIME_ZONES. If not time zones, can you explain what you mean as I cannot see any countries in 4.5.

Hope this helps

Ruth
http://www.teamultra.net
Robert S. Falko
Acclaimed Contributor.

Re: countires database table

Hi,

The countries appear in a drop-down list when you enter an address.

I'll be derned if I can find any table that contains them. Could they be hard coded?

-Josh
Ruth Porter
Acclaimed Contributor.

Re: countires database table

Hi there,

I think Josh is correct and it must be hardcoded - if you look at the data dictionary for Address the country is given as:

Country/Region, Country or region name. (Text 50)

which is certainly not a reference to another table.

But if you try typing in rather than selecting from the list it lets you type in thename of a country not on the list.

Hope this helps

Ruth

http://www.teamultra.net
Elias Abboud
Acclaimed Contributor.

Re: countires database table

Thanks a lot for your replies.

This is exactly why I posted the question.

I searched and could not find any table containing Them. It is for a custom report I want to create. Anyways I found another way to do it.

Thanks again.
If you can't solve it, post it :)
Tulio Quinones
Outstanding Contributor.

Re: countires database table

How did you do it?