Using SBEAMS

From SPCTools

---

Revision as of 19:01, 15 June 2009

Miscellaneous useful SQL queries

If you need to change schema constraints after defining your schema:

1. Change the constraint in $SBEAMS/conf/PeptideAtlas/PeptideAtlas_table_column.txt
2. Actually make the schema change:

ALTER TABLE employee  ADD CONSTRAINT pk_employee PRIMARY KEY (EmployeeId)
ALTER TABLE employee DROP CONSTRAINT pk_employee