Once the creation of a table is over, one can perform two changes in t

1.	Once the creation of a table is over, one can perform two changes in the schema of the table. What are they? Give syntax.
Answer» We can alter the table in two ways. We can add a new column to the existing table using the following syntax, ALTER TABLE <tablename>ADDD(<cloumnname><type><constraint>); We can also change or modify the existing column in terms of type or size using the following syntax, ALTER TABLE <tablename>MODIFY(<column><newtype>);

Once the creation of a table is over, one can perform two changes in the schema of the table. What are they? Give syntax.

Answer»

We can alter the table in two ways.

syntax,

ALTER TABLE

<tablename>ADDD(<cloumnname><type><constraint>);

We can also change or modify the existing column in terms of type or size using the following

syntax,

ALTER TABLE

<tablename>MODIFY(<column><newtype>);