Computer scienceFundamentalsSQL and DatabasesBasics SQLData Definition Language

Basic CREATE statement

Theory

Staff information

Report a typo

Create a table named staff with these columns:

  • first_name (will store a string with a maximum length of 50 characters)
  • last_name (will store a string with a maximum length of 50 characters)
  • badge_id (will store a number)
  • department (will store a string with a maximum length of 30 characters)
  • position (will store a string with a maximum length of 15 characters)
Write an SQL statement





___

Create a free account to access the full topic