CREATE a new table

From SQLZOO
Revision as of 14:46, 12 July 2012 by Marek (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

CREATE a new table

schema:gisq

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