SQL create table
Create Table
Tables are a basic unit of organization and storage of data in SQL. Each table has a name such as an author, book_mast, purchase or orders. A table is similar to a file in a non-database system.
Tables are organized into rows and columns. Each row represents a record, and each column can be thought of as representing a component of that record.
Syntax:
CREATE TABLE <table_name>( column1 data_type[(size)], column2 data_type[(size)], ...);
Parameters:
Name | Description |
---|---|
table_name | Name of the table where data is stored. |
column1,column2 | Name of the columns of a table. |
data_type | Char, varchar, integer, decimal, date and more. |
size | Maximum length of the column of a table. |
SQL create table basic statement
The following will describe, how a simple table can be created.
Example:
The following example creates a table. Here is the field name and data types:
Field Name | Data Type | Size | Decimal Places | NULL |
---|---|---|---|---|
agent_code | char | 6 | No | |
agent_name | char | 40 | No | |
working_area | char | 35 | No | |
commission | decimal | 10 | 2 | No |
phone_no | char | 15 | Yes |
the following SQL statement can be used:
SQL Code:
CREATE TABLE mytest(
agent_code char(6),
agent_name char(40),
working_area char(35),
commission decimal(10,2),
phone_no char(15) NULL);
To see the structure of the created table:
SQL Code:
DESCRIBE mytest;
Output:
Name Null? Type --------------------------- -------- ------ AGENT_CODE CHAR(6) AGENT_NAME CHAR(40) WORKING_AREA CHAR(35) COMMISSION NUMBER(10,2) PHONE_NO CHAR(15)
Check out our 1000+ SQL Exercises with solution and explanation to improve your skills.
Previous: Create/Alter Database
Next: Primary Key
- Weekly Trends
- Python Interview Questions and Answers: Comprehensive Guide
- Scala Exercises, Practice, Solution
- Kotlin Exercises practice with solution
- MongoDB Exercises, Practice, Solution
- SQL Exercises, Practice, Solution - JOINS
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- JavaScript String Exercises
- JavaScript HTML Form Validation
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join