Assignment - Foreign Constraints | MySQL
Added on - 22 Sep 2019
14
pages
1245
Words
110
Views
0
Downloads
INFS ASSIGNMENT 21|P a g e28October,2016DATABASEQUERYREPORTSTUDENT
ContentsCREATETABLESTATEMENTS.................................................................................................................2SELECTSTATEMENTS.............................................................................................................................7SQLQUERIES........................................................................................................................................10SQLVIEWS...........................................................................................................................................112|P a g e
CREATE TABLE STATEMENTSCreatetableONLINE_CLINICIAN(OIDintprimarykey,Phonedouble,eMailvarchar(20),FNamevarchar(20),LNamevarchar(20),Addressvarchar(50));createtableHOME_USER(UIDvarchar(20)primarykey,Phonedouble,eMailvarchar(20),FNamevarchar(20),LNamevarchar(20),Addressvarchar(50),OIDint,constrainth_fkforeignkey(OID)referencesONLINE_CLINICIAN(OID)ondeletesetnull);createtableQUESTION(QIDintprimarykey,QTextvarchar(30),Typevarchar(20),QTimestamptimestamp,3|P a g e

You’re reading a preview

To View Complete Document
Become a Desklib Library Member.
Subscribe to our plans