Difference between revisions of "CREATE a new table"

From SQLZOO
Jump to: navigation, search
 
(One intermediate revision by one user not shown)
Line 1: Line 1:
 
CREATE a new table
 
CREATE a new table
 
<div class='ht'>
 
<div class='ht'>
<div class=params>schema:gisq</div>
+
<div class=params>schema:scott</div>
 
<div>
 
<div>
 
The following are examples of field types:
 
The following are examples of field types:
Line 31: Line 31:
 
</div>
 
</div>
 
</div>
 
</div>
{{SELECT Ref}}
+
 
 +
{{CREATE and DROP ref}}

Latest revision as of 10:42, 16 July 2012

CREATE a new table

schema:scott

The following are examples of field types:

INTEGERA whole number
VARCHAR(10)Up to 10 characters.
CHAR(10)Fixed number of characters
DATEA date
TIMESTAMPDate and time
FLOATFloating point numbers
DROP TABLE t_test
 
CREATE TABLE t_test
 (a INTEGER NOT NULL PRIMARY KEY
 ,b VARCHAR(10)
 )
CREATE TABLE t_test
 (a INTEGER PRIMARY KEY
 ,b VARCHAR2(10)
 )
CREATE TABLE t_test
 (a INTEGER PRIMARY KEY
 ,b VARCHAR(10)
 )
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense