SQL Keyword ALTER COLUMN
The ALTER COLUMN keyword can be used to change the data type of a column.
The below SQL changes the data type of column "birth_date" to type "year".
ALTER TABLE employees
ALTER COLUMN birth_date year;The ALTER COLUMN keyword can be used to change the data type of a column.
The below SQL changes the data type of column "birth_date" to type "year".
ALTER TABLE employees
ALTER COLUMN birth_date year;If you find the content useful and like to share it with others, you can click the below link to share on social platforms.
The content can be shared on most of the popular social networking platforms.
Your feedback and suggestions are important to us, as they help us grow stronger.
If you wish to share your feedback or suggestions, you can write to us at the below email address.
We have some interesting and useful online tools that can be used to perform some of the tasks that we struggle to do on a daily basis.
You can take a look and make use of them to simplify your software development and testing.
We have some interesting and useful online tools that can be used to perform some of the tasks that we struggle to do on a daily basis.
You can take a look and make use of them to simplify your software development and testing.
We publish some useful content on YouTube on a regular basis, which will be useful for you.
You can take a look and subscribe to the YouTube channel if you wish to receive updates on videos we publish on YouTube.
You can also share your feedback and suggestions on YouTube in the form of like, share, comment and subscription.