Query Set #0g – displaying our tables

To confirm that a table (for example, PATIENT) was made correctly, we can use the SELECT * FROM PATIENT; query (we will explain this syntax further in Query Set #2):

sqlite> SELECT * FROM PATIENT;
1 John A Smith 1952-01-01 1206 Fox Hollow Rd. Pittsburgh PA 15213 6789871234 M
2 Candice P Jones 1978-02-03 1429 Orlyn Dr. Los Angele CA 90024 3107381419 F
3 Regina H Wilson 1985-04-23 765 Chestnut Ln. Albany NY 12065 5184590206 F
4 Harold Lee 1966-11-15 2928 Policy St. Providence RI 02912 6593482691 M
5 Stan P Davis 1958-12-30 4271 12th St. Atlanta GA 30339 4049814933 M
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset