Question

Using the sports database containing two relations (TEAM, MATCH_DETAILS) and write the Query for the following:

Change the name of the relation TEAM to T_DATA. Also, change the attributes TeamID and TeamName to T_ID and T_NAME respectively.

Answer 1

ALTER TABLE TEAM

RENAME TO T DATA:

ALTER TABLE T_DATA

RENAME COLUMN TeamID TO T_ID;

ALTER TABLE T_DATA

RENAME COLUMN TeamName TO T_NAME;