INSY 3432 Chapter Notes - Chapter 7: Data Definition Language, Concatenation, Stored Procedure

• School: Fordham University
• Department: Information and Communications Systems
• Course: INSY 3432
• Professor: Kamesam

Document Summary

Add mycolumn char(5) null: sql drop column clause removes columns from table, format, alter table customer. Drop column mycolumn: adding & dropping constraints, sql add constraint clause adds constraint, format, alter table customer. Add constraint myconstraint check (lastname not in ( robersnopay")): sql drop constraint clause removes constraint, format, alter table customer. Insert into artist (lastname, firstname, nationality, dataofbirth, datedeceased) Values ( miro", joan", spanish", 1893, 1983): bulk insert, format. Insert into artist (lastname, firstname, nationality, dateofbirth, datedeceased) From imported_artist: sql update statement, sql update statement used to change values of existing rows, format, update. Customerid = 1000: updating using values from other tables, format, update. Purchase_order. city = bodega bay": sql merge statement: sql command that is essentially combo of sql insert & sql. Update statements where insert to update is performed depending upon existing data: format, merge into artist as a using artist_data_research as. Dateofbirth, datedeceased): sql delete statement, format, delete from customer.