Flashcards
INSERT UPDATE DELETE statements
Flashcards do conjunto (6)
- 1TO UPDATE THE RECORD YOU NEED TO WRITE ALL THE COLUMN NAMES AND INCLUDE VALUES FOR ALL OF THEMFALSE
- 2I CAN CHANGE THE DATA TYPE FOR DATA COLUMN USING UPDATE STATEMENT EX. CHANGE PHONE NUMBER FIELD TO BE STORED AS A TEXTFALSE
- 3BY RUNNING THIS STATEMENT DELETE SURNAME FROM STAFF; COLUMN SURNAME WILL BE DELETED FROM TABLEFALSE - ALL TABLE RECORDS WILL BE DELETED
- 4I RUN UPDATE STATEMENT AND I WANT TO GO BACK TO PREVIOUS DATASHEET VIEW BEFORE I RUN MY QUERY I CAN RESTORE THE PREVIOUS VIEW BY HITTING BACK ARROW KEY IN MS ACCESSFALSE
- 5YOU CAN WRITE INSERT STATEMENT WITHOUT DEFINING ALL OF THE COLUMNS AND ITS VALUES WITHIN TABLETRUE
- 6WHEN INSERT STATEMENT WILL NOT WORK IF YOU DEFINE ONLY SOME COLUMNS FROM DATA TABLE?WHEN PRESENCE CHECK VALIDATION IS ENABLED FOR COLUMN WHICH IS NOT DEFINED IN INSERT STATEMENT
Informações
- Descrição
- A level Computing FlashCards sobre INSERT UPDATE DELETE statements, criado por ADRIANNA DAR em 30-11-2020.
- Criado por
- ADRIANNA DAR
- Visualizações
- 0
- Avaliação