Constraints - Revision history

Bacchas at 23:46, 13 November 2017

2017-11-13T23:46:59Z

← Older revision		Revision as of 23:46, 13 November 2017
Line 34:		Line 34:
	ADD CONSTRAINT product_id_pk		ADD CONSTRAINT product_id_pk
	PRIMARY KEY(id, name, product);		PRIMARY KEY(id, name, product);

			== DROP A CONSTRAINT ==
			ALTER TABLE tablename
			DROP CONSTRAINT constraint_name_pk

	[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]		[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]

Bacchas at 23:43, 13 November 2017

2017-11-13T23:43:35Z

← Older revision		Revision as of 23:43, 13 November 2017
Line 29:		Line 29:
	ADD CONSTRAINT bk_str_rep_id_fk FOREIGN KEY(rep_id)		ADD CONSTRAINT bk_str_rep_id_fk FOREIGN KEY(rep_id)
	REFERENCES STORE_REPS(rep_id)		REFERENCES STORE_REPS(rep_id)

			== ADDING MULTI COLUMN CONSTRAINTS TO AN EXISTING TABLE ==
			ALTER TABLE sales
			ADD CONSTRAINT product_id_pk
			PRIMARY KEY(id, name, product);

	[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]		[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]

Bacchas at 13:27, 18 October 2017

2017-10-18T13:27:09Z

← Older revision		Revision as of 13:27, 18 October 2017
Line 29:		Line 29:
	ADD CONSTRAINT bk_str_rep_id_fk FOREIGN KEY(rep_id)		ADD CONSTRAINT bk_str_rep_id_fk FOREIGN KEY(rep_id)
	REFERENCES STORE_REPS(rep_id)		REFERENCES STORE_REPS(rep_id)

			[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]

Bacchas at 23:25, 13 October 2017

2017-10-13T23:25:41Z

← Older revision		Revision as of 23:25, 13 October 2017
Line 24:		Line 24:
	ALTER TABLE customers		ALTER TABLE customers
	ADD CONSTRAINT customers_cust_no_pk PRIMARY KEY(customer#);		ADD CONSTRAINT customers_cust_no_pk PRIMARY KEY(customer#);

			== Create A Foreign Key Constraint ==
			ALTER TABLE BOOK_STORES
			ADD CONSTRAINT bk_str_rep_id_fk FOREIGN KEY(rep_id)
			REFERENCES STORE_REPS(rep_id)

Bacchas at 17:03, 13 October 2017

2017-10-13T17:03:41Z

← Older revision		Revision as of 17:03, 13 October 2017
Line 1:		Line 1:
	= Constraints PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, NOT NULL =		= Constraints PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, NOT NULL =
			''' NOT NULL has to be added at the column level, cannot be added at the table level'''
			''' If a primary key consist of more than one column (composite primary key) you must create it at the table level'''
	== Adding Constraints at table creation ==		== Adding Constraints at table creation ==
	CREATE TABLE a_animals(		CREATE TABLE a_animals(
Line 13:		Line 15:

	);		);
	~~''' NOT NULL has to be added at the column level, cannot be added at the table level'''~~
	== Check Constraint on a specific Table ==		== Check Constraint on a specific Table ==
	SELECT constraint_name, constraint_type		SELECT constraint_name, constraint_type

Bacchas at 16:23, 13 October 2017

2017-10-13T16:23:45Z

← Older revision		Revision as of 16:23, 13 October 2017
Line 13:		Line 13:

	);		);
			''' NOT NULL has to be added at the column level, cannot be added at the table level'''
			== Check Constraint on a specific Table ==
			SELECT constraint_name, constraint_type
			FROM user_constraints
			WHERE table_name = 'A_ANIMALS';

	== ~~Check Constraint on a specific~~ Table ==		== Add Constraints to Existing Table/column==
			ALTER TABLE customers
			ADD CONSTRAINT customers_cust_no_pk PRIMARY KEY(customer#);

Bacchas: Created page with "= Constraints PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, NOT NULL = == Adding Constraints at table creation == CREATE TABLE a_animals( animal_id NUMBER(6), name VARCHAR2(25),..."

2017-10-13T16:07:42Z

Created page with "= Constraints PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, NOT NULL = == Adding Constraints at table creation == CREATE TABLE a_animals( animal_id NUMBER(6), name VARCHAR2(25),..."

New page

= Constraints PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, NOT NULL =
== Adding Constraints at table creation ==
CREATE TABLE a_animals(
animal_id NUMBER(6),
name VARCHAR2(25),
license_tag_number NUMBER(10),
admit_date DATE CONSTRAINT ail_admit_date_nn NOT NULL,
adoption_id NUMBER(5),
vaccination_date DATE CONSTRAINT ail_vaccination_date_nn NOT NULL,

CONSTRAINT ail_animal_id_pk PRIMARY KEY(animal_id),
CONSTRAINT ail_license_pk UNIQUE(license_tag_number)

);

== Check Constraint on a specific Table ==