SQL: SQL stands for “Structured Query Language”. The current version of SQL is “ANSI SQL – 92”. It contains constructs which are used to define and process database . They are executed using DBMS-supplied command prompt. SQL is not a programming language. It is text-based and it is also called as data sublanguage. In order to get SQL as a complete programming language, it should be included in scripting languages like Java, C#, and so on. DROP TABLE statement: “DROP TABLE” statement comes under Data Definition Language. It is used to delete the information and to delete the structure of the table. The syntax to drop a table is as follows. Syntax: DROP TABLE table_Name; ALTER TABLE Statement: “ALTER TABLE” statement comes under Data Definition Language. It is used to modify column, add constraints, add column(s), drop column, rename column name and table name, drop constraints, and so on. Syntax: Syntax to drop constraint is as follows: ALTER TABLE table_Name DROP CONSTRAINT constraintName;

Question

Want to see the full answer?

Answer 1

Question

Chapter 3, Problem 3.13RQ

Program Plan Intro

SQL:

SQL stands for “Structured Query Language”.

The current version of SQL is “ANSI SQL – 92”.

It contains constructs which are used to define and process database. They are executed using DBMS-supplied command prompt.

SQL is not a programming language. It is text-based and it is also called as data sublanguage. In order to get SQL as a complete programming language, it should be included in scripting languages like Java, C#, and so on.

DROP TABLE statement:

“DROP TABLE” statement comes under Data Definition Language. It is used to delete the information and to delete the structure of the table. The syntax to drop a table is as follows.

Syntax:

DROP TABLE table_Name;

ALTER TABLE Statement:

“ALTER TABLE” statement comes under Data Definition Language. It is used to modify column, add constraints, add column(s), drop column, rename column name and table name, drop constraints, and so on.

Syntax:

Syntax to drop constraint is as follows:

ALTER TABLE table_Name DROP CONSTRAINT constraintName;

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Write the SQL statements necessary to remove the PET_OWNER table from the database. Assume that the PET table also needs to be removed. Do not run these commands in an actual database!

Execute the following statements using MYSQL: 1. Insert a row with the values (005, "Your name", , "Your Dept", 50000, 40) 2. Create a trigger (model trigger) to ensure that no employee of salary less than 20000 can be inserted in the database. Show the result for your trigger condition by inserting a new row.

PLZ help with the following: The manager wants to add a new painter as an artist in the database. What would the insert statement look like? For a painter to be considered in the Artist database, the painter must have painted at least one painting, however, a painting might not be exhibited in a gallery. Based on these business rules, please insert one painting for the painter that you inserted in Q1. sql file CREATE TABLE GALLERY (GAL_NUM char(4),GAL_OWNER varchar(35),GAL_AREACODE char(3),GAL_PHONE char(8),GAL_RATE number);INSERT INTO GALLERY VALUES('5','L. R. Gilliam','901','123-4456',0.37);INSERT INTO GALLERY VALUES('6','G. G. Waters','405','353-2243',0.45 );INSERT INTO GALLERY VALUES('1','N. D. Cosner','203','123-9956',0.67);INSERT INTO GALLERY VALUES('2','S. H. Artwork','415','154-3243',0.30); /* -- */ CREATE TABLE PAINTER (PTR_NUM char(4),PTR_LASTNAME varchar(15) NOT NULL,PTR_FIRSTNAME varchar(15) NOT NULL,PTR_AREACODE char(3),PTR_PHONE char(8));INSERT INTO PAINTER…