Exam (elaborations)
D427 Questions and Answers | New One | Grade A+
- Course
- Institution
Add a column to a table Ans: ALTER TABLE table_name ADD column_name datatype; CREATE VIEW Ans: CREATE VIEW view_name AS SELECT column_name(s) FROM table_name WHERE condition Viewing a View Ans: SELECT * FROM Viewname Adding a primary key Ans: ALTER TABLE Movie ADD PRIMARY KEY (ID); Add...
[Show more]