Question

Create and edit table using DDL Commands​

Answer 1

Explanation:

The DDL command ALTER TABLE is used to perform such actions. Alter command provides multiple utilities exclusive for schema objects. The ALTER TABLE statement is used to add, drop, rename, and modify a column in a table. The below ALTER TABLE statement renames the table EMP to EMP_NEW

Answer 2

Explanation:

SQL DDL commands

The DDL commands in SQL are used to create database schema and to define the type and structure of the data that will be stored in a database. SQL DDL commands are further divided into the following major categories:

CREATE

ALTER

DROP

TRUNCATE

CREATE

The CREATE query is used to create a database or objects such as tables, views, stored procedures, etc.

Creating a database

The following example demonstrates how the CREATE query can be used to create a database in MS SQL Server: