createschema.sql

Creating your SQL Server Compact Edition database and schema in code

CREATE TABLE Suppliers(
      SupplierID nVarChar(10) NOT NULL CONSTRAINT Suppliers_PK PRIMARY KEY,
      CompanyName nvarchar(40) NOT NULL,
      Description nvarchar(100) NULL,
      SortOrder int NOT NULL DEFAULT(50),
      Active bit NOT NULL DEFAULT (1) 
)
GO
CREATE TABLE OrderStatus(
      OrderStatus nChar(10) NOT NULL CONSTRAINT OrderStatus_PK PRIMARY KEY,
      Status nvarchar(40) NOT NULL,
      Description nvarchar(100) NULL,
      SortOrder int NOT NULL DEFAULT(50),
      Active bit NOT NULL DEFAULT (1) 
)
GO
INSERT INTO Suppliers  (SupplierID, CompanyName, Description, SortOrder, Active)
VALUES ('1', 'Exotic Liquids', 'Things that make your skin warm', 1, 1)
GO
INSERT INTO Suppliers  (SupplierID, CompanyName, Description, SortOrder, Active)
VALUES ('2', 'New Orleans Cajun Delights', 'Things that make your stomach warm', 2, 1)
GO
INSERT INTO Suppliers  (SupplierID, CompanyName, Description, SortOrder, Active)
VALUES ('3', 'Grandma Kelly''s Homestead', 'Great bread products', 4, 1)
GO
INSERT INTO Suppliers  (SupplierID, CompanyName, Description, SortOrder, Active)
VALUES ('4', 'Tokyo Traders', 'All sorts of cool stuff', 4, 1)
GO