We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

How do I create a Constraint in FireBird

JoshWegener
JoshWegener asked
on
Medium Priority
642 Views
Last Modified: 2013-12-09
I am writing a progam that converts MySQL database into a FireBird database... what is the SQL code (isql) to create a Constraint on a table?
Comment
Watch Question

Nick UpsonPrincipal Operations Engineer
CERTIFIED EXPERT

Commented:
a trigger looks like this (artwork is the name of the table)

CREATE TRIGGER ARTWORK_I FOR ARTWORK
ACTIVE BEFORE INSERT POSITION 0
AS

begin
IF ((new.artwork_u is NULL) OR (new.artwork_u < 1)) THEN
  new.artwork_u = gen_id(gen_artwork, 1);

end

a constraint is on a field in the table

CREATE TABLE ARTWORK (
       ARTWORK_U INTEGER NOT NULL,
       DATE_SUBMITTED TIMESTAMP NOT NULL,
       DATE_RETURNED TIMESTAMP,
      CONSTRAINT ARTWORK_PK PRIMARY KEY (ARTWORK_U)
);

Author

Commented:
I need a FK Constraint
Principal Operations Engineer
CERTIFIED EXPERT
Commented:
ALTER TABLE EMPLOYEE ADD CONSTRAINT EMPLOYEE_FK1 FOREIGN KEY (JOBDESC) REFERENCES JOBDESC(JOBDESC_U);

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.