Question

Q6. Write the Create database Student & create table syntax with example: Student Table {Columns ST_ID,ST_NAME, ST_ROLL }

Answer 1

Command:

Create database Student;

Create table student(St_ID int, ST_NAME varchar (20), ST_ROLL int );

Explanation:

• Create database/ table creates a database/ table respectively.
• While creating a table you have to assign the names of the column and the respective datatypes within parentheses.