Write a query to rename the Table consumers to Consumer_Data. Print the Table Schema once created as follows: SELECT table_name, column_name, data_type FROM information_schema.columns WHERE table_name = ORDER BY column_name;

Write a query to rename the Table consumers to Consumer_Data.
Print the Table Schema once created as follows:

    SELECT table_name, column_name, data_type

    FROM information_schema.columns

    WHERE table_name = <TABLE_NAME>

    ORDER BY column_name;

CODE:

ALTER TABLE consumers

    rename to consumer_data;

  SELECT table_name, column_name, data_type

    FROM information_schema.columns

    WHERE table_name = 'consumer_data'

    ORDER BY column_name;