How to create a table in SQL - Syntax for creating a table in SQL, SQL Query for creating a table

How to create a table in SQL - Syntax for creating a table in SQL, SQL Query for creating a table

A table is a collection of rows and columns
Syntax for creating a Table :-

create table <table_name>(column_name1 datatype(range),column_name2 datatype(range),.................,column_nameN datatype(range))

Example for creating a Table for Students Records :-

create table student_info(stu_name varchar(30),stu_father_name varchar(30),stu_address varchar(100),stu_contact number(10))

Tweet