1.

Enlist Some Commands Of Ddl?

Answer»

CREATE: Create is used in the CREATE TABLE statement.
SYNTAX is:  CREATE TABLE [COLUMN name] ( [column DEFINITIONS] ) [ table PARAMETERS]

ALTER: It helps in modification of an existing object of database.
Syntax is: ALTER objecttype objectname parameters.

DROP: It destroys an existing database, INDEX, table or view.
Syntax is: DROP objecttype objectname.

CREATE: Create is used in the CREATE TABLE statement.
Syntax is:  CREATE TABLE [column name] ( [column definitions] ) [ table parameters]

ALTER: It helps in modification of an existing object of database.
Syntax is: ALTER objecttype objectname parameters.

DROP: It destroys an existing database, index, table or view.
Syntax is: DROP objecttype objectname.


Discussion

No Comment Found

Related InterviewSolutions