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.

More Articles

 

Share your thought



PLEASE DISABLE ADBLOCKER AND SUPPORT US!

Please support us by enabling ads on this page. Refresh

YOU DON'T LIKE ADS, WE ALSO DON'T LIKE ADS!
 
But we have to show ads on our site to keep it free and updated. We have to pay huge server costs, domain costs, CDN Costs, Developer Costs, Electricity and Internet Bill. Your little contribution will encourage us to regularly update this site.