Does Domain Exist

Thread View: borland.public.interbase.ibconsole

5 messages

[T] Back to Threads [V] Tree View [G] Group Articles

5 total messages Started by Peter Batten Mon, 22 Oct 2007 23:33

#179

Author: Peter Batten
Date: Mon, 22 Oct 2007 23:33

7 lines
1167 bytes

Is there a RDB$ table I can use to test if a Domain exists.

If not what SQL statement can I use to check for domain existence?

TIA

Peter

Re: Does Domain Exist

#180

Author: Bill Todd
Date: Tue, 23 Oct 2007 00:16

16 lines
1269 bytes

Peter Batten wrote:

> Is there a RDB$ table I can use to test if a Domain exists.
> 
> If not what SQL statement can I use to check for domain existence?
> 
> TIA
> 
> Peter

SELECT * FROM RDB$FIELDS WHERE RDB$FIELD_NAME NOT LIKE 'RDB$%'

will list all of the domains.

-- 
Bill Todd (TeamB)

Re: Does Domain Exist

#181

Author: Peter Batten
Date: Tue, 23 Oct 2007 01:08

20 lines
1458 bytes

Thanks Bill

"Bill Todd" <no@no.com> wrote in message
news:471d3d7b$1@newsgroups.borland.com...
> Peter Batten wrote:
>
> > Is there a RDB$ table I can use to test if a Domain exists.
> >
> > If not what SQL statement can I use to check for domain existence?
> >
> > TIA
> >
> > Peter
>
> SELECT * FROM RDB$FIELDS WHERE RDB$FIELD_NAME NOT LIKE 'RDB$%'
>
> will list all of the domains.
>
> -- 
> Bill Todd (TeamB)

Re: Does Domain Exist

#182

Author: Quinn Wildman (CodeGear Develope...
Date: Tue, 23 Oct 2007 16:49

14 lines
1357 bytes

I assume the purpose of the question here is replacing a domain. I 
that's the case, as with all other InterBase objects, I just drop first 
and then create.

Peter Batten wrote:
> Is there a RDB$ table I can use to test if a Domain exists.
> 
> If not what SQL statement can I use to check for domain existence?
> 
> TIA
> 
> Peter
> 
>

Re: Does Domain Exist

#183

Author: Bill Todd
Date: Tue, 23 Oct 2007 17:00

5 lines
1060 bytes

More likely he is trying to determine if a domain does not exist and
needs to be added.

-- 
Bill Todd (TeamB)

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads