Oprette tabeller via SQL statement
Hvordan fyrer jeg nedenstående af til en db ? Hjælp mig gerne med komplet source kode :)if exists (select * from dbo.sysobjects where id = object_id(N\'[dbo].[info]\') and OBJECTPROPERTY(id, N\'IsUserTable\') = 1)
drop table [dbo].[info]
GO
if exists (select * from dbo.sysobjects where id = object_id(N\'[dbo].[stillinger]\') and OBJECTPROPERTY(id, N\'IsUserTable\') = 1)
drop table [dbo].[stillinger]
GO
CREATE TABLE [dbo].[info] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[info_overskrift] [varchar] (8000) NULL ,
[info_forfatter] [varchar] (8000) NULL ,
[info_date] [datetime] NULL ,
[info_abstrakt] [varchar] (8000) NULL ,
[info_indledning] [varchar] (8000) NULL ,
[info_broedtekst] [varchar] (8000) NULL ,
[info_links] [varchar] (8000) NULL ,
[info_status] [int] NULL ,
[info_kind] [int] NULL ,
[info_show] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[stillinger] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[stilling_beskrivelse] [varchar] (8000) NULL ,
[stilling_indledning] [varchar] (8000) NULL ,
[stilling_abstrakt] [varchar] (8000) NULL ,
[stilling_arbejdsomraader] [varchar] (8000) NULL ,
[stilling_branchekendskab] [varchar] (8000) NULL ,
[stilling_erfaringer] [varchar] (8000) NULL ,
[stilling_uddannelse] [varchar] (8000) NULL ,
[stilling_alder] [varchar] (8000) NULL ,
[stilling_rejseaktivitet] [varchar] (8000) NULL ,
[stilling_loen] [varchar] (8000) NULL ,
[stilling_sprog] [varchar] (8000) NULL ,
[stilling_bobael] [varchar] (8000) NULL ,
[stilling_link] [varchar] (8000) NULL ,
[stilling_kontaktperson] [varchar] (8000) NULL ,
[stilling_dato] [datetime] NULL ,
[stilling_kind] [varchar] (255) NULL ,
[stilling_status] [int] NULL ,
[stilling_show] [int] NULL ,
[stilling_email] [varchar] (8000) NULL
) ON [PRIMARY]
GO
