---
title: "Create Table Statement in SQL"  
description: "In this blog, I’m trying to explain the create table statement in sql.  You need tables in database to store data. Create Table statement is used to c"  
author: "Sumit Kesarwani"  
published: 2013-05-18  
updated: 2014-09-18  
canonical: https://www.mindstick.com/blog/511/create-table-statement-in-sql  
category: "database"  
tags: ["database"]  
reading_time: 1 minute  

---

# Create Table Statement in SQL

In this blog, I’m trying to [explain](https://www.mindstick.com/forum/157854/what-is-system-debugging-explain-some-system-debugging-tools-used-in-modern-computer-systems) the [create table](https://www.mindstick.com/articles/443/how-to-create-table-in-sql-server) [statement in sql](https://www.mindstick.com/forum/33706/what-is-the-difference-between-having-clause-and-group-by-statement-in-sql-server).\

You need [tables](https://www.mindstick.com/articles/336597/introduction-of-html-tables-for-web-development) in [database](https://www.mindstick.com/articles/12226/use-of-database-in-sencha-extjs-and-insert-record-from-user-form-using-ajax) to store data. Create [Table statement](https://www.mindstick.com/forum/159777/how-to-add-a-new-column-to-an-existing-sql-table-using-the-alter-table-statement) is used to create tables in database.

Syntax:

CREATE TABLE [tablename](https://www.mindstick.com/forum/34722/how-to-get-label-text-from-table-reference-on-database-based-on-tablename-and-fieldname) ([column name](https://www.mindstick.com/forum/369/how-can-i-add-a-column-name-to-my-grid) [datatype](https://www.mindstick.com/forum/32/stored-procedure-return-datatype)(size),column name datatype(size));

where

· tablename - name of the table

· column name - name of the column

· datatype - datatype of the column

· size – size of datatype

##### Example

```
CREATE TABLE student(student_id int,student_name varchar(30),student_address varchar(30),student_mobile int,student_branch varchar(10),student_date_of_birth date);
```

This statement creates the table name [student](https://www.mindstick.com/articles/157138/student-loan-default-wage-garnishment-and-student-loan) with column student_id, student_name, student_address, student_mobile, student_branch, student_date_of_birth

---

Original Source: https://www.mindstick.com/blog/511/create-table-statement-in-sql

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.