CREATE TABLE Buildings
(
	BuildingID	int NOT NULL,
	AddressID       int NOT NULL,
	PRIMARY KEY(BuildingID),
	UNIQUE (AddressID) 
)
exec sp_addextendedproperty 'MS_Description', N'Здания', 'user', 'dbo', 'Table', 'Buildings'
exec sp_addextendedproperty 'MS_Description', N'Код здания', 'user', 'dbo', 'Table', 'Buildings', 'Column', 'BuildingID'
exec sp_addextendedproperty 'MS_Description', N'Адрес', 'user', 'dbo', 'Table', 'Buildings', 'Column', 'AddressID'
