public void Test_07_CreateTable()
{
DBQuery create = DBQuery.Create.Table("dbo", "MoreCategories")
.Add("mc_id", DbType.Int32, DBColumnFlags.AutoAssign)
.Add("mc_name", DbType.String, 50)
.Add("mc_desc", DbType.String, 255, DBColumnFlags.Nullable)
.Add("mc_ot_id", DbType.Int32, DBColumnFlags.Nullable)
.Add("mc_ot_name", DbType.AnsiString, 50, DBColumnFlags.Nullable)
.Constraints(
DBConstraint.PrimaryKey("pk_Id_and_name").Columns("mc_id", "mc_name")
);
this.OutputAndValidate(create, " Create Table with primary key constraint");
}
