SQL Tutorial: How to Modify a Columns Data Type

Explore the full SQL Course on Udemy:

In this video you will learn how to:

- Alter Tables within a Database
- Modify a columns data type within a database table.

#sql
#postgresql
#sqltutorial

[vlrslh]

How to convert all column data types into nvarchar datatype in table

[srijanandi]

Hello Jon, I have watched your sql videos on Udemy but was unable to understand the significance of constraint name.. Please help me to clear this doubt..

[avinashjha]

ALTER TABLE payment
ALTER COLUMN amount TYPE INT
USING amount::integer;