What are various DDL commands in SQL? Give brief description of their – InterviewSolution

InterviewSolution

1.

What are various DDL commands in SQL? Give brief description of their purposes.

Answer»

Following are various DDL or Data Definition Language commands in SQL −

CREATE − it creates a new table, a view of a table, or other object in database.
ALTER − it modifies an existing database object, such as a table.
DROP − it deletes an entire table, a view of a table or other object in the database.

Discussion

No Comment Found

Related InterviewSolutions

Say True or False. Give explanation if False.A view doesn’t have data of its own.
What is a view? Why should you use a view?
Which SQL statement is used to add, modify or drop columns in a database table?
Say True or False. Give explanation if False.A DROP TABLE statement can be rolled back.
What is the difference between VARCHAR2 AND CHAR datatypes?
Say True or False. Give explanation if False.A DDL statement or a DCL statement is automatically committed.
What is the purpose of the MERGE statement in SQL?
Say True or False. Give explanation if False.You can use a subquery in an INSERT statement.
Say True or False. Give explanation if False.Attempting to delete a record with a value attached to an integrity constraint, returns an error.
Can you remove rows from a table based on values from another table? Explain.