Question

class 8th question

how will you insert a new field in an existing table ?

​

Answer 1

Answer:

On the Fields tab, in the Add & Delete group, click More Fields. Select a field in the More Fields list to insert the new column.

Explanation:

..tq friend

Answer 2

For inserting a new field in an existing table, use the ALTER statement. The ALTER TABLE statement is used to add, delete, or modify columns in an existing table.

General syntax :-

ALTER TABLE table_name ADD column_name datatype;

For example, you have an employees table and you have to add the mobile field in the table, following can be used :-

ALTER TABLE employees ADD mobile int(11);

Note :- The usage statement remains the same for MySQL, Oracle, PostgreSQL databases.