✏️ Explanatory Question

How to create a table in SQL?

👁 466 Views

📘 Detailed Answer

466

Total Views

Related Qs

Progress

💡

Answer with Explanation

SQL provides an organized way for table creation:

Syntax

Create table TableName (columnName1 datatype, columnName2 datatype )

The following is an example of creating a simple table.

create table Info   
(   
   Name varchar(20),   
   BirthDate date,   
   Phone nvarchar(12),   
   City varchar(20)   
)

📌 Topic Information

Subject SQL

Chapter SQL Table

Sub-Chapter Create table

Type Short Answer

Published 09 Apr 2020