Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

SQL

memorize.ai (lvl 286)

(0)

21 cards

()

Section 1

Preview this deck

Foreign Key

Front

1 / 21

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (21)

Section 1

(21 cards)

Foreign Key

Front

This is a consistency check which ensures each value in this column corresponds to another value in a column in another table

Back

Default

Front

Sets a (blank) value for a column when no value is given

Back

Semicolon

Front

All statements end with this

Back

Alter Table

Front

Use this statement to modify an existing table

Back

Database Objects

Front

This is any defined object in a database that is used to store or reference data

Back

Not Null & Default

Front

Use these statements when you don't know if a column exists in a table

Back

Schema

Front

A collection of database objects associated with a particular database username

Back

Unique

Front

This means that the values in this column have to be (blank) so you can't insert another row with the same value in this column as another row in the table. Doesn't have to be a key for a row in the table.

Back

Rows

Front

This is sometimes called a record. It's a set of fields within a table that are relevant to a specific entry

Back

Table

Front

Is the primary storage object for data in a relational database, and consists of row(s) and column(s).

Back

Drop Table

Front

Use this statement to remove an entire table.

Back

IF EXISTS

Front

Use this statement to see if a specific table is present

Back

Create Table & Select

Front

Use these statements to make a new table from an existing table

Back

Columns

Front

This is the part of the table that holds a particular piece of data for the record and sometimes called a field. They are assigned a particular data type.

Back

Autoincrement

Front

For integer values this means that the value is automatically filled in and incremented with each row insertion. Not supported in all databases.

Back

Create Table

Front

This is the statement you want to use for a new table.

Back

Alter table & alter column

Front

Statements you want to use to to change the column attributes

Back

Check

Front

Expression, this allows you to run a more complex expression to test whether the values inserted are value.

Back

Primary Key

Front

This means that the values in this column are unique and each value can be used to identify a single row in this table.

Back

Index

Front

Used to create and retrieve data from the database very quickly

Back

Drop

Front

Use this statement to remove columns

Back