Skip to content

Instantly share code, notes, and snippets.

@andrelashley
Last active August 29, 2015 14:09
Show Gist options
  • Save andrelashley/e51f35a8e8b6f1b46b8f to your computer and use it in GitHub Desktop.
Save andrelashley/e51f35a8e8b6f1b46b8f to your computer and use it in GitHub Desktop.
query
use tyresense3
go
IF OBJECT_ID('Tyresense3..#AreaMaps') IS NOT NULL DROP TABLE #AreaMaps
CREATE TABLE dbo.AreaMaps
(
Id int constraint PK_AreaMaps primary key,
BoundingBox nvarchar(255) not null,
Name nvarchar(255) not null,
MapImage varbinary(max) not null,
AreaID int not null constraint FK_AreaMaps_Areas foreign key references Areas (AreaId)
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment