CSE :: Database System 2 - CS
- The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.
- Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause.
- The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors.
- The SQL DELETE statement is used to delete both the table structure and table data.
- Common types of SQL CHECK constraints include range checks and limiting columns values.
- If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data.
- When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.
Whatsapp
Facebook
