Friday , June 21 2024

Table Change (ALTER) Operations

In today’s article, we will examine how to change tables in a table using the ALTER command.

1. Change Table Name.

2. Add Columns to the Table

The value of existing records in this column is updated to NULL.

If NULL is not desired, a DEFAULT value is assigned.

3. Change the Column

If a column is given a default value with the MODIFY word, existing records are not affected. It is valid only for records to be newly inserted.

We can increase the size of a column, but when decreasing it, it is necessary to know the size of the largest data, otherwise problems may occur.

4. Change the Column Name



Leave a Reply

Your email address will not be published. Required fields are marked *