Create Table In SQL
In SQL CREATE TABLE Query is used to
create a new table in a database.
If You Want to Create a table in
Database then You Have To Define the Name of Table,Column name and Its
Data Types.
Create table Syntax-
SQL>CREATE TABLE table_name (column1
datatype, column2 datatype,column3 datatype,
....);
Create Table Example-
SQL> CREATE TABLE STUDENTS ( ID INT
NOT NULL, NAME VARCHAR (20) NOT
NULL, AGE INT NOT NULL, ADDRESS CHAR (25), PRIMARY KEY (ID) );
Here ID column is int type it means it will
accept the integer and data type (Not Null) Means We can not leave the ID
column Blank
Here name Column is Varchar (20) It
Means It accept the numeric and alpha .and limit of character is 20.
Create Table Real Time Example-
SQL>CREATE TABLE Employee (
EmployeeID int, FirstName
varchar(50), LastName varchar(50), Email varchar(50), Address varchar(100), State varchar(50)
);
Create Table Using Existing Table-
We can Create anew table by using a
existing table with Following Command
It Will Copy all name and data type
of Existing Table And create a new table With Another name
Syntax-
SQL>CREATE TABLE new_table_name AS
SELECT column1, column2,... FROM existing_table_name WHERE ....;
Example-
SQL>CREATE TABLE Test Table AS SELECT
customername, contactname FROM customers;
Tags:
sql