CIS 336 help Making Decisions/uophelp.com CIS 336 help Making Decisions/uophelp.com | Page 44

contents of each table in turn. Inspect your query results to ensure that each column and
row from
each of the tables is as expected. Correct and repeat testing of your script until no errors
occur, and the
results match expectations. You may also use the DESCRIBE command to display the
table structure of
each table, and verify that PK and NULL constraints have been properly created. The
SHOW CREATE
TABLE statement is useful for displaying the SQL that would regenerate a given table,
which is a useful
way for checking that FKs have been properly created.
Examples:
DESCRIBE STUDENT;
SHOW CREATE TABLE STUDENT;
This is the end of Lab 3
---------------------------------------------------------------------------------
CIS 336 iLab 4 Introduction to Select, Insert, Update, and Delete Statements (only SQL
Command, No output)
For more course tutorials visit
www.uophelp.com
CIS336: Lab 4: Introduction to Select, Insert, Update, and Delete Statements