Column types

From MyWiki
Revision as of 14:38, 25 September 2014 by George2 (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
CREATE TABLE Orders
(
OrderId INT NOT NULL,
ProductName VARCHAR(50) NOT NULL,
OrderDate datetime NOT NULL DEFAULT NOW(),
PRIMARY KEY (OrderId)
)