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
SQL: Tips of the Day
SQL Query to concatenate column values from multiple rows in Oracle-
Table A:
PID A B C
Table B:
PID SEQ Desc A 1 Have A 2 a nice A 3 day. B 1 Nice Work. C 1 Yes C 2 we can C 3 do C 4 this work!
SELECT pid, LISTAGG(Desc, ' ') WITHIN GROUP (ORDER BY seq) AS description FROM B GROUP BY pid;
Output of the SQL should be -
PID Desc A Have a nice day. B Nice Work. C Yes we can do this work!
Database: Oracle
Ref: https://bit.ly/3ySR8o4
- Weekly Trends
- 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
- JavaScript functions Exercises
- Python Tutorial
- Python Array Exercises
- SQL Cross Join
- C# Sharp Array Exercises
We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook