[syntax type=”js”]CREATE TABLE ModuleHouseTradingPackage(
Id INT NOT NULL PRIMARY KEY,
LanguageId INT NOT NULL FOREIGN KEY REFERENCES dbo.Language(Id),
Name NVARCHAR(MAX) NULL,
Description NVARCHAR(MAX) NULL,
HouseLimit INT NOT NULL DEFAULT 0, –0 Is Unlimited
ImgLimit INT NOT NULL DEFAULT 0, –0 Is Unlimited
Price DECIMAL NOT NULL DEFAULT 0, –Price of package
CurrencyId INT NOT NULL FOREIGN KEY REFERENCES dbo.Currency(Id)
);[/syntax]

Tạo bảng trong MSSQL Server

Category: DatabaseMSSQL Server
0
1385 views

Join the discussion

Your email address will not be published. Required fields are marked *