SQL Create Table

The SQL Create Table is used to create new table in the database.

Create Table Syntax :

The syntax of the Create Table is −
In creating a basic table involves, define the naming of the table (table-name) and its columns (column 1, column 2 ..... column) and the datatype of each column (column 1 datatype ...... column 2 data Type).

CREATE TABLE table-name (
column1 datatype,
column2 datatype,
column3 datatype,
.
.
.
columnN datatype
); 



Create Table Example :

The following code block is an example, which creates a table name Customer that contains the following column names (CustomerID, CustomerName, Age, Address, Customer List), where CustomerID is a primary key and not NULL.

CREATE TABLE Customer(
CustomerID   INT              NOT NULL,
CustomerName VARCHAR (20)     NOT NULL,
Age  INT              NOT NULL,
Address  CHAR (25) ,
CustomerSalary   DECIMAL (18, 2),       
PRIMARY KEY (ID)
);



The empty "Customer" table will now look like this:

CustomerID CustomerName Age Address CustomerSalary





Visit :


Discussion



* You must be logged in to add comment.

pHqghUme
555

pHqghUme
555

pHqghUme
555

pHqghUme
-1 OR 2+788-788-1=0+0+0+1 --

pHqghUme
-1 OR 3+788-788-1=0+0+0+1 --

pHqghUme
-1 OR 3*2<(0+5+788-788) --

pHqghUme
-1 OR 3*2>(0+5+788-788) --

pHqghUme
-1 OR 2+138-138-1=0+0+0+1

pHqghUme
-1 OR 3+138-138-1=0+0+0+1

pHqghUme
-1 OR 3*2<(0+5+138-138)

pHqghUme
-1 OR 3*2>(0+5+138-138)

pHqghUme
-1' OR 2+143-143-1=0+0+0+1 --

pHqghUme
-1' OR 3+143-143-1=0+0+0+1 --

pHqghUme
-1' OR 3*2<(0+5+143-143) --

pHqghUme
-1' OR 3*2>(0+5+143-143) --

pHqghUme
-1' OR 2+866-866-1=0+0+0+1 or 'J8sIZs1y'='

pHqghUme
-1' OR 3+866-866-1=0+0+0+1 or 'J8sIZs1y'='

pHqghUme
-1' OR 3*2<(0+5+866-866) or 'J8sIZs1y'='

pHqghUme
-1' OR 3*2>(0+5+866-866) or 'J8sIZs1y'='

pHqghUme
-1" OR 2+256-256-1=0+0+0+1 --

pHqghUme
-1" OR 3+256-256-1=0+0+0+1 --

pHqghUme
-1" OR 3*2<(0+5+256-256) --

pHqghUme
-1" OR 3*2>(0+5+256-256) --

pHqghUme
if(now()=sysdate(),sleep(15),0)

pHqghUme
0'XOR(if(now()=sysdate(),sleep(15),0))XOR'Z

pHqghUme
0"XOR(if(now()=sysdate(),sleep(15),0))XOR"Z

pHqghUme
(select(0)from(select(sleep(15)))v)/*'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"*/

pHqghUme
-1; waitfor delay '0:0:15' --

pHqghUme
-1); waitfor delay '0:0:15' --

pHqghUme
1 waitfor delay '0:0:15' --

pHqghUme
J2mnKQ5a'; waitfor delay '0:0:15' --

pHqghUme
-5 OR 73=(SELECT 73 FROM PG_SLEEP(15))--

pHqghUme
-5) OR 976=(SELECT 976 FROM PG_SLEEP(15))--

pHqghUme
-1)) OR 67=(SELECT 67 FROM PG_SLEEP(15))--

pHqghUme
RSDWFuLV' OR 177=(SELECT 177 FROM PG_SLEEP(15))--

pHqghUme
W3cudZyP') OR 732=(SELECT 732 FROM PG_SLEEP(15))--

pHqghUme
UbL3iV2F')) OR 205=(SELECT 205 FROM PG_SLEEP(15))--

pHqghUme
555*DBMS_PIPE.RECEIVE_MESSAGE(CHR(99)||CHR(99)||CHR(99),15)

pHqghUme
555'||DBMS_PIPE.RECEIVE_MESSAGE(CHR(98)||CHR(98)||CHR(98),15)||'

pHqghUme
1'"

pHqghUme

pHqghUme
@@Iz8x5

pHqghUme
555

pHqghUme
555

pHqghUme
555