sql1.sct

来自「c#设计模式WithCla」· SCT 代码 · 共 18 行

CREATE TABLE CLASS_NAME
(
[  ATTRIBUTE_NAME ATTRIBUTE_TYPE ATTRIBUTE_USER1 ATTRIBUTE_NOT_NULL ATTRIBUTE_UNIQUE ,
] 
SELECT_WHEN ATTRIBUTE_IS_PRIMARY_KEY [ PRIMARY KEY (ATTRIBUTE_NAME), ]
SELECT_WHEN ATTRIBUTE_IS_FOREIGN_KEY [ FOREIGN KEY associates (ATTRIBUTE_NAME) REFERENCES ATTRIBUTE_NAME$_Table , ]
);

SELECT_WHEN ATTRIBUTE_IS_INDEX
[
CREATE ATTRIBUTE_USER2 INDEX by$ATTRIBUTE_NAME
  ON CLASS_NAME (ATTRIBUTE_NAME);]

CLASS_USER1
CLASS_USER2
CLASS_USER3