Question

Write any three DDL commands.

Answer 1

1. CREATE TABLE Command:
   You can create a table by using the CREATE TABLE command.
   CREATE TABLE Student
   (Admno integer,
   Name char(20), \
   Gender char(1),
   Age integer,
   Place char(10),
   );
2. ALTER COMMAND:
   The ALTER command is used to alter the table structure like adding a column, renaming the existing column, changing the data type of any column or size of the column, or deleting the column from the table.
   Alter table Student add address char;
3. DROP TABLE:
   The drop table command is used to remove a table from the database.
   DROP TABLE Student;