· 6 years ago · Nov 06, 2019, 03:34 PM
1CREATE TABLE IF NOT EXISTS `BI_OLTP_24`.`TB_Address` (
2 `AddressID` INT NOT NULL,
3 `AddressLine` VARCHAR(45) NOT NULL,
4 `City` VARCHAR(45) NOT NULL,
5 `StateProvince` VARCHAR(45) NULL,
6 `PostalCode` VARCHAR(45) NOT NULL,
7 `CountryRegion` VARCHAR(45) NOT NULL,
8 PRIMARY KEY (`AddressID`))
9ENGINE = InnoDB;