The SQL Alter Table Statement

preview_player
Показать описание
This video explains how to use the ALTER TABLE statement of the Structured Query Language (SQL). It is the second in a series about a subset of SQL known as the Data Definition Language (DDL), which can be used to create and modify the table structures within a relational database. It includes examples of how to use ALTER TABLE to add, drop and alter columns in a table. It also explains how to add a new primary key constraint to an existing column in a table, and how to add a foreign key constrain to an existing column. Some variations between MySQL, SQL Server and Microsoft Access are mentioned.
Рекомендации по теме
Комментарии
Автор

years later and still very helpful, i like the enthusiasm, thank you ❤

nnfglhc
Автор

man i had a question about my upcoming exam and first video i stumble across is yours and i couldnt be more satisfied. you fully answered what i was looking for. kudos to you kind sir :)

lassda
Автор

Thanks for the concise tutorial, very helpful.

BreadWinner
Автор

Thank you for this video, it's comes in handy when studying sql.

alefushimi
Автор

Thank you so much. It facilitates a lot.

hsumyathtike