Dbms- concepts (delete table, not null, add column, create table from table)

Create table. Add 10 entities. Add another column using alter command. Update all city with nagpur. Create Another Table With the name of report & store some information (name, email) using select into with conditions.

How to delete table:- DROP table tablename; How to create NOT NULL column:- CREATE TABLE student(roll int, name varchar(50), mobile vachar(50) NOT NULL; How to add column in existing table:- ALTER COMMAND is used to adding new column in a table. ALTER TABLE student ADD city varchar(50); SP_HELP student; Sp command is returning the structure of database. How to create table from table:- SELECT INTO command SELECT name,mobile INTO stu from student; SELECT * FROM stu;