Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ballarat]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ballarat]
GO
CREATE TABLE [dbo].[ballarat] (
[id] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[streetname] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[suburb] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[postcode] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[precinct] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[honumber] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[specialinstructions] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[comments] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.