SQL data definition and manipulation commands

1234567891011121314
Across
  1. 3. how you would add a column to a database
  2. 5. used to limit the value range that can be placed in a column.
  3. 7. used to limit the number of rows returned
  4. 8. allows you to rename a column or table using an alias
  5. 10. is a way to insert data into a table
  6. 11. selects records that have matching values in two tables
  7. 12. returns all rows from the right table, and the matched rows from the left table
  8. 13. used to combine rows and aggregate data
  9. 14. used to update a record in a table
Down
  1. 1. determines which columns of the data to show in the results
  2. 2. returns all rows from the left table, and the matched rows from the right table
  3. 4. is used to delete a record in a table
  4. 5. it creates a table in the database
  5. 6. used to get data from multiple tables
  6. 9. will count the number of rows and return that count as a column in the result set.