if not Exists(SELECT * FROM information_schema.tables where Table_name = 'Car') begin Create table dbo.Car ( ID int Primary key, Mat_ID bigint references dbo.matter(id) not null, Taf_ID bigint references dbo.Tafsili(id) not null, Code int not null, Plaque nvarchar(50) not null, Pro_ID_Brand int references OtherProperties(ID) null, Model nvarchar(200) null, Pro_ID_Color int references OtherProperties(ID) null, Pro_ID_Brake int references OtherProperties(ID) null,-- ترمز Pro_ID_ManufactoryCountry int references OtherProperties(ID) null, -- کشور سازنده ConstructionYear nvarchar(200) null, -- سال ساخت CylinderCount nvarchar(200) null, EnginVolume nvarchar(200) null, -- حجم موتور Pro_ID_FuelType int references OtherProperties(ID) null, [Power] nvarchar(200) null, Pro_ID_Gearbox int references OtherProperties(ID) null, -- نوع گیربکس Pro_ID_PowerTransmission int references OtherProperties(ID) null, -- نوع انتقال قدرت Acceleration nvarchar(200) null, --شتاب MaxSpeed nvarchar(200) null, [Weight] nvarchar(200) null, Size nvarchar(200) null, FuelConsumptionInCity nvarchar(200) null, FuelConsumptionOutCity nvarchar(200) null, TankVolume nvarchar(200) null, EmissionStandard nvarchar(200) null, Airbag nvarchar(200), SoundSystem nvarchar(200) null, [Description] nvarchar(1000) null, Dom_ID_Active int references dbo.Domain(ID) not null ) end