Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support definition of foreign keys in CREATE TABLE statement #24

Open
andyjefferson opened this issue Apr 11, 2016 · 0 comments
Open

Support definition of foreign keys in CREATE TABLE statement #24

andyjefferson opened this issue Apr 11, 2016 · 0 comments

Comments

@andyjefferson
Copy link
Member

Some RDBMS allow specification of FOREIGN KEYs at the end of a CREATE TABLE statement. We should allow it.

CREATE TABLE TBL1
(
ID INT NOT NULL,
COL1 INT,
FOREIGN KEY (COL1) REFERENCES TBL2 (COLX)
)

The complication is that the related table needs to exist, so need to introduce ordering into table creation whereas without this we don't (and just send the CREATE FK statement when both tables exist)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant