D-E Flashcards
1
Q
Creates or deletes an SQL database
A
Database
2
Q
A constraint that provides a default view for a column
A
Default
3
Q
Deletes rows from a table
A
Delete
4
Q
Sorts the result set in descending order
A
Desc
5
Q
Selects only distinct (different) columns
A
Distinct
6
Q
Deletes a column constraint database index table or view
A
Drop
7
Q
Deletes a column in a table
A
Drop Column
8
Q
Deletes a Unique Primary Key Foreign Key or Check constraint
A
Drop Constraint
9
Q
Deletes an existing SQL database
A
Drop Database
10
Q
Deletes a Default constraint
A
Drop Default
11
Q
Deletes an Index in a table
A
Drop Index
12
Q
Deletes an existing table in the database
A
Drop Table
13
Q
Deletes a View
A
Drop View
14
Q
Executes a stored Procedure
A
Exec
15
Q
Tests for the existence of any record in a sub query
A
Exists
