Home Up

Db_007 Generatrix

Overlooking the world of SBS2003 and Office Systems 2003

 

 

 

OLAppointmentTable.sql

(Note:  The generatrix is a macro that the database creates from the definition of the table that will delete and recreate the table when it is run in tsql.  It is stored as a text file with .sql extension in the ...\MSSQL7\Binn directory.  When tsql is run from the SQL Server Manager's Tools Menu, it will open to the Binn directory and show all the .sql files for selection.)

 

if exists (select * from sysobjects where id = object_id(N'[dbo].[OLAppointments]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[OLAppointments]
GO

CREATE TABLE [dbo].[OLAppointments] (
[Id] [int] IDENTITY (1, 1) NOT NULL ,
[Starttime] [smalldatetime] NULL ,
[EndTime] [smalldatetime] NULL ,
[Subject] [nvarchar] (100) NULL ,
[Conversation] [nvarchar] (110) NULL ,
[Contacts] [nvarchar] (100) NULL ,
[Categories] [nvarchar] (100) NULL ,
[Location] [nvarchar] (50) NULL ,
[MessageClass] [nvarchar] (50) NULL ,
[Created] [datetime] NULL ,
[CreatedBy] [nvarchar] (50) NULL ,
[Name] [nvarchar] (50) NULL ,
[Billing] [nvarchar] (50) NULL ,
[Mileage] [nvarchar] (50) NULL ,
[Body] [nvarchar] (500) NULL ,
[ItemID] [nvarchar] (256) NULL 
) ON [PRIMARY]
GO

 

Send mail to Hollis@outlookbythesound.com with questions or comments about this web site.
Last modified: October 31, 2003