Computer Science
Which command defines its columns, integrity constraint in create table :
- Create table command
- Drop table command
- Alter table command
- All of these
DDL & DML
3 Likes
Answer
Create table command
Reason — The CREATE TABLE command is used to define a new table in SQL, and it allows to define the columns of the table along with any integrity constraints such as primary keys, foreign keys, unique constraints, etc.
Answered By
1 Like
Related Questions
…………… defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.
- Column
- Constraint
- Index
- Trigger
Fill in the blank :
…………… command is used to remove primary key from a table in SQL.
- update
- remove
- alter
- drop
Which command is used for removing a table and all its data from the database :
- Create table command
- Drop table command
- Alter table command
- All of these
Which of the following is not a DDL command ?
- UPDATE
- TRUNCATE
- ALTER
- None of these