SQL Commands

Edit Answers
123456789101112131415161718
Across
  1. 1. creates a new table
  2. 4. is used to limit the value range that can be placed in a column.
  3. 8. creates a new database
  4. 9. ives us a way to sort the result set by one or more of the items
  5. 12. modifies a table
  6. 13. deletes a table
  7. 17. count the number of rows and return that count as a column in the result set.
  8. 18. creates an index (search key)
Down
  1. 2. modifies a database
  2. 3. extracts data from a database
  3. 5. inserts new data into a database
  4. 6. deletes data from a database
  5. 7. clause is used to limit the number of rows returned
  6. 10. allows you to combine rows and aggregate data count the number of rows and return that count as a column in the result set
  7. 11. clause to get data from multiple tables
  8. 12. allows you to rename a column or table using an alias.
  9. 13. deletes an index
  10. 14. used to calculate the average of a numeric column from the set of rows returned
  11. 15. to limit the selected rows to the items when a column has a certain pattern of characters contained in it.
  12. 16. updates data in a database