View structures of all tables created by you.
Q. View structures of all tables created by you. Answer = Desc Employee ; Desc…
Q. View structures of all tables created by you. Answer = Desc Employee ; Desc…
Q. Create table Employee as per following Table Instance Chart. Table -- A…
Q. Create table Department as per following Table Instance Chart. Table --- …
Q. Drop the column CustomerlncomeGroup from table Customer. Table -- Answ…
Q. Insert few records with relevant information, in the table. Table -- An…
Q. Add one more column CustomerincomeGroup of datatype VARCHAR(10). Table -- …
Q. Add one column Email of data type VARCHAR and size 30 to the table Customer.…
Q. Create table Customer as per following Table Instance Chart. Table -- A…
Q. Drop table Employee and Department. Answer = Drop table Employee ; Drop tabl…
Q. Create the table Employee based un the following table instance chart. Table…
Q. Populate the table Department with data from table dept. Including only requ…
Q. Create the table Department table based on the following table instance char…
Q. Drop the table Empl. Table - Answer = Drop table Empl ;
Q. Modify the definition of column Grade. Increase its size to 2. Table -- …
Q. Insert a record of your choice in table Empl. Make sure not to enter Grade. …
Q. Add a constraint (NN-Grade) in table Empl that declares column Grade not nul…
Q. In the added column Grade, assign grades as follows – if sal is in range 70…
Q. Modify table Empl, add another column called Grade of VARCHAR type, size 1 i…
Q. Write Query statements for following transaction : (Consider tables of ques…
Q. Enlist the names of all tables created by you. Answer = Show tables ;