- Study guides, Class notes & Summaries
Looking for the best study guides, study notes and summaries about ? On this page you'll find 5 study documents about .
5 results
Exam (elaborations)
D191 Advanced data management (SQL) review solution
D191 Advanced data management (SQL) review solution
Exam (elaborations)
D191 Advanced data management(SQL) Questions And Answers Graded 2023
PopularTRUNCATE TABLE - delete all data from table leaving structure intact 
 
DROP TABLE - deletion of a table 
 
DELETE FROM table_name 
 WHERE conditional; - delete specific data/rows from a table 
 
DROP DATABASE - Dropping a database 
 
ALTER TABLE table_name 
ALTER COLUMN column_name TIMESTAMP 
DEFAULT current_timestamp; - adding column in table to store a timestamp 
 
ALTER TABLE table_name 
ALTER COLUMN column_name1 
TYPE CHARACTER VARYING( ), 
ALTER COLUMN column_name1 
SET NOT NULL; - modify ...
Exam (elaborations)
D191 Advanced data management (SQL) review solution
D191 Advanced data management (SQL) review solution
Exam (elaborations)
D191 Advanced data management (SQL) review solution.
D191 Advanced data management (SQL) review solution.
Exam (elaborations)
D191 Advanced data management(SQL) Questions And Answers Graded 2023
TRUNCATE TABLE - delete all data from table leaving structure intact 
 
DROP TABLE - deletion of a table 
 
DELETE FROM table_name 
 WHERE conditional; - delete specific data/rows from a table 
 
DROP DATABASE - Dropping a database 
 
ALTER TABLE table_name 
ALTER COLUMN column_name TIMESTAMP 
DEFAULT current_timestamp; - adding column in table to store a timestamp 
 
ALTER TABLE table_name 
ALTER COLUMN column_name1 
TYPE CHARACTER VARYING( ), 
ALTER COLUMN column_name1 
SET NOT NULL; - modify ...