SQL Tutorial - 55: The ALTER TABLE Command

In this tutorial we'll see how we can modify the structure of a table through the ALTER TABLE command in SQL.

The command allows us to add, drop or modify fields in a table.

Thanks for watching!

[pawanjakke]

I have learned totally in just a Day. great series.

[kamanurisrinivasulu]

How to insert values in a column after alter the table?, example in this video default column have null then how to insert data in that place, which syntax is there?

[Ayushkumar-scix]

Everything I wanted to know...
Thanks very much

[twot]

please make a tutorial on 'how we can create relationship between tables?'
one to one
one to many
many to many

[ridhisharma]

how to insert the values in new column sir? I still have doubt.

[inderpreetsingh]

how to get missed ids count of serial numbers...like 101, 102, 103, 105, 106...how to get 104 from this..with query

[yogitamane]

Sir How to apply identity command in a particular column using alter command

[KemTech]

How do I add values to and existing table? eg I have a table with a price column ($29, $30, $70) I want to add $20 where $70 is to make it a total of 90. How do I do that?

[NoraAlfraidi]

Why I couldn’t add double cause I want large number like the number of population

[ka]

can you alter table in temporal tables without creating and only changing something in column

[pawanjakke]

What is the difference for varchar(m) and char(m) sir?

[haimepiphany]

may i know where is the run button? is it the "apply" button or not?

[bobbyrios]

Followed video verbatim, but keep getting an error: ALTER TABLE employee MODIFY name CHAR(30) NOT NULL; Error Code: 1138. Invalid use of NULL value.

[augustoliver]

Nice video. Could you make a video like this one, but with ALTER TABLE ADD CONSTRAINT ? Thank you

[shaheenkirasoi]

Doesn't really work on Oracle 18c Enterprise Edition.

[VikramSingh-kecz]

Tell me bro how to alter enum column in database..

[shahnawazabdulrehman]

are you alright brother? You haven't uploaded in a long while.

[Shakirkhan-xifw]

How we can find your other vidoes of my sql

[ysbharath]

We can't copy... City field  data from other tables... using any command..???

[vivekuniyal]

Hello sir, I was wondering if we could modify the column..?