What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-03-21 21:30:58
alter table add column and foreign key mysql
-- On Create CREATE TABLE tableName ( ID INT, SomeEntityID INT, PRIMARY KEY (ID), FOREIGN KEY (SomeEntityID) REFERENCES SomeEntityTable(ID) ON DELETE CASCADE ); -- On Alter, if the column already exists but has no FK ALTER... Add solution -
Python 2022-03-20 02:15:44
python create table postgresql
.wp-block-code { border: 0; padding: 0; } .wp-block-code > div { overflow: auto; } .shcb-language { border: 0; clip: rect(1px, 1px, 1px, 1px); -webkit-clip-path: inset(50%); clip-path: inset(50%); height: 1px; margin: -1px; overflow: hidden... Add solution -
SQL 2021-10-17 16:47:04
alter constraint in sql
You can not alter constraints ever but you can drop them and then recreate. Have look on this ALTER TABLE your_table DROP CONSTRAINT ACTIVEPROG_FKEY1; and then recreate it with ON DELETE CASCADE like this ALTER TABLE your_table add CONSTRA... Add solution
Best helpers
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5