Question

How to apply constraint on multiple field after creating table in sql server?

Answer 1

CREATE TABLE x( x VARCHAR2(20), y NUMBER(2) NOT NULL, CONSTRAINT fk_cons FOREIGN KEY(x) REFERENCES user_info(user_id), CONSTRAINT null_cons CHECK(x IS NOT NULL) )