CCing list. No reply yet. On 01/05/2013 12:21 PM, Carey Gagnon wrote:
Not sure what info you need Adrian. Will this do?CREATE TABLE [dbo].[Companies]( [CompanyID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL, [CompanyName] [nvarchar](50) NOT NULL, [Address] [nvarchar](50) NOT NULL, [City] [nvarchar](50) NULL, [CityID] [int] NULL, [ProvinceState] [nvarchar](2) NULL, [Country] [nvarchar](50) NULL, [PostalZIP] [nvarchar](50) NULL, [Phone] [nvarchar](50) NULL, [Fax] [nvarchar](50) NULL, [Website] [nvarchar](50) NULL, [InactiveCompany] [bit] NOT NULL, [CompanyActivationDate] [datetime] NOT NULL, [CompanyInactivationDate] [datetime] NULL, [CompanyCreator] [nvarchar](50) NOT NULL, [ParentCompanyID] [int] NULL, [CompanyRating] [nvarchar](50) NULL, CONSTRAINT [PK_Companies] PRIMARY KEY CLUSTERED CREATE TABLE [dbo].[Cities]( [CityID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL, [CityName] [nvarchar](64) NOT NULL, [ProvinceState] [nvarchar](2) NOT NULL, CONSTRAINT [PK_Cities] PRIMARY KEY CLUSTERED ALTER TABLE [dbo].[Cities] WITH CHECK ADD CONSTRAINT [FK_Cities_ProvinceState] FOREIGN KEY([ProvinceState]) REFERENCES [dbo].[ProvinceState] ([ProvinceState]) CREATE TABLE [dbo].[ProvinceState]( [ProvinceState] [nvarchar](2) NOT NULL, [Country] [nvarchar](50) NOT NULL, CONSTRAINT [PK_ProvinceState] PRIMARY KEY CLUSTERED Carey
-- Adrian Klaver [email protected] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
