>Hi,
>
>I have a table with the following DDL:
>
>CREATE TABLE LOCALITY (
>ID INTEGER NOT NULL,
>PARENT_IDINTEGER,
>CT_NODETYPES_ID INTEGER,
>DESCRIPTION VARCHAR(30),);
>
>The foreign key: CT_NODETYPES_ID refers to a table CT_NODETYPES with the
>followi
Hello Maxi,
Check constraints are table based, not column based.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
From: mailto:firebird-support@yahoogroup
Hi,
I need to get a check constraints info, listing column names.
I do:
SELECT *
FROM rdb$triggers trg
JOIN rdb$check_constraints chk_k ON trg.rdb$trigger_name =
chk_k.rdb$trigger_name
WHERE
trg.rdb$relation_name = 'SCHEMA_AUTHOR'
AND
trg.rdb$trigger_type = 1
Hi,
If you accidently use Delphi and ReportBuilder (also Delphi & IntraWeb), then
have a look at: ReportBuilder Export Devices PRO - Overview
http://www.rarefind.com/rbpro/
ReportBuilder Export Devices PRO - Overview http://www.rarefind.com/rbpro/
Export your ReportBuilder reports to PD
Hi,
I have a table with the following DDL:
CREATE TABLE LOCALITY (
ID INTEGER NOT NULL,
PARENT_IDINTEGER,
CT_NODETYPES_ID INTEGER,
DESCRIPTION VARCHAR(30),
);
The foreign key: CT_NODETYPES_ID refers to a table CT_NODETYPES with the
fo