Copyright

SQL DROP Columns & Rows: Tutorial

Instructions:

Choose an answer and hit 'next'. You will receive your score and answers at the end.

question 1 of 3

The correct syntax for dropping a column in SQL Server is:

Create Your Account To Take This Quiz

As a member, you'll also get unlimited access to over 79,000 lessons in math, English, science, history, and more. Plus, get practice tests, quizzes, and personalized coaching to help you succeed.

Try it risk-free
Try it risk-free for 30 days. Cancel anytime
Already registered? Log in here for access

1. To drop/delete a row of data, use the _____ command.

2. A(n) _____ is required at the end command.

Create your account to access this entire worksheet
A Premium account gives you access to all lesson, practice exams, quizzes & worksheets
Access to all video lessons
Quizzes, practice exams & worksheets
Certificate of Completion
Access to instructors
Create an account to get started Create Account

About This Quiz & Worksheet

This quiz and worksheet combo will help you gauge your understanding of the vocabulary and syntax of the DROP command in SQL. Questions will ask you to choose key terms from a definition as well as explain what syntactic changes will do to commands.

Quiz & Worksheet Goals

Through these questions, you can review your knowledge of:

  • The correct syntax for dropping a column or row in SQL
  • The terms for a record of data and field of data
  • What is required at the end of a command

Skills Practiced

  • Critical thinking - apply knowledge of SQL syntax to correctly answer questions about how SQL commands will be carried out
  • Defining key concepts - ensure that you can accurately define main phrases, such as record of data and data field
  • Knowledge application - use your knowledge to answer questions such as the correct syntax needed for different commands in SQL

Additional Learning

You can find more information about the DROP command in SQL by viewing the lesson titled SQL DROP COlumns & Rows: Tutorial. This lesson will cover topics such as:

  • Correct command syntax in different database systems
  • Real-world examples of commands in action
  • What happens to data when you drop a column
Support