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)
Practice SQL Exercises
- SQL Exercises, Practice, Solution
- SQL Retrieve data from tables [33 Exercises]
- SQL Boolean and Relational operators [12 Exercises]
- SQL Wildcard and Special operators [22 Exercises]
- SQL Aggregate Functions [25 Exercises]
- SQL Formatting query output [10 Exercises]
- SQL Quering on Multiple Tables [8 Exercises]
- FILTERING and SORTING on HR Database [38 Exercises]
- SQL JOINS
- SQL SUBQUERIES
- SQL Union[9 Exercises]
- SQL View[16 Exercises]
- SQL User Account Management [16 Exercise]
- Movie Database
- BASIC queries on movie Database [10 Exercises]
- SUBQUERIES on movie Database [16 Exercises]
- JOINS on movie Database [24 Exercises]
- Soccer Database
- Introduction
- BASIC queries on soccer Database [29 Exercises]
- SUBQUERIES on soccer Database [33 Exercises]
- Hospital Database
- Employee Database
- More to come!
Want to improve the above article? Contribute your Notes/Comments/Examples through Disqus.
Previous: Create/Alter Database
Next: Primary Key
SQL: Tips of the Day
SQL Server SELECT into existing table.
INSERT INTO dbo.TABLETWO SELECT col1, col2 FROM dbo.TABLEONE WHERE col3 LIKE @search_key
This assumes there's only two columns in dbo.TABLETWO - you need to specify the columns otherwise:
INSERT INTO dbo.TABLETWO (col1, col2) SELECT col1, col2 FROM dbo.TABLEONE WHERE col3 LIKE @search_key
Database: SQL Server
Ref: https://bit.ly/3y6tpA3
- New Content published on w3resource:
- HTML-CSS Practical: Exercises, Practice, Solution
- Java Regular Expression: Exercises, Practice, Solution
- Scala Programming Exercises, Practice, Solution
- Python Itertools exercises
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework
- Angular - JavaScript Framework
- Vue - JavaScript Framework
- Jest - JavaScript Testing Framework