SQL: DEFAULT Constraint flash cards

Set: SQL: DEFAULT Constraint

Familiarize		Learn		Test
Play Scatter			Play Space Race

Term	Definition
DEFAULT	is used to insert a default value into a column
CREATE TABLE table_name (column_name1 DEFAULT, column_name2, )	to create a table with a DEFAULT constraint on a column
ALTER TABLE table_name ALTER COLUMN column_name DEFAULT value	to create a DEFAULT constraint on a column when the table is already created
ALTER TABLE table_name ALTER COLUMN column_name DROP DEFAULT	to drop a DEFAULT constraint

No Messages

Report as inappropriate