How can we create tables in SQL?

SQL
#1

In SQL, creating a table is as easy as typing the following command:

CREATE TABLE employee(
    emp_id varchar(20),
    emp_name varchar(50),
    salary int,
    dept_id varchar(20),
    manager_id varchar(20)
);

Output

emp_id emp_name alary dept_id manager_id

Prior to stating the table’s name, we will first state the CREATE TABLE keywords. The list of all the columns and their associated data types will follow in braces.