SQL Create Table

In this chapter you will learn:
About create table
Syntax of create table
Example of create table

About create table

SQL statement create table is used to create a new table in a database. You can create a table in the system defined database or a database you have created.

Syntax of create table

create table student_info
( 
value data-type,
value data-type
)

Example of create table

create table employee
(
emp_name varchar(20),
emp_age int,
emp_mobile_no bigint
)
create table

table with column name emp_name, emp_age and emp_mbile_no has created as-

create table result SUMMARY

In this chapter, you have learned how to create a table so now you can create a table with this command. In the next chapter you will learn about rename table.

 

Share your thought