SQLize | PHPize | SQLtest

CREATE TABLE [dbo].[Арендаторы]( [№аренд] [int] NOT NULL, [ФИО] [nvarchar](50) NULL, [Адрес] [nvarchar](50) NULL, [№тел] [nvarchar](50) NULL, [Требтип] [nvarchar](50) NULL, [Максаренда] [nvarchar](50) NULL, [№отд] [int] NULL, CONSTRAINT [PK_Арендаторы] PRIMARY KEY CLUSTERED ( [№аренд] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO CREATE TABLE [dbo].[Отделение]( [№отд] [int] NOT NULL, [Улица] [nvarchar](50) NULL, [Район] [nvarchar](50) NULL, [Город] [nvarchar](50) NULL, [Индекс] [nvarchar](50) NULL, [№тел] [nvarchar](50) NULL, [№факса] [nvarchar](50) NULL, CONSTRAINT [PK_Отделение] PRIMARY KEY CLUSTERED ( [№отд] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Арендаторы] WITH CHECK ADD CONSTRAINT [FK_Арендаторы_Отделение] FOREIGN KEY([№отд]) REFERENCES [dbo].[Отделение] ([№отд]) GO ALTER TABLE [dbo].[Арендаторы] CHECK CONSTRAINT [FK_Арендаторы_Отделение] GO