- SQL code
DROP TABLE Test;CREATE TABLE Test( dates DATE NOT NULL DEFAULT(CURRENT_TIMESTAMP));--这样可以 CREATE TABLE Test( dates DATE NOT NULL, CONSTRAINT DFT_dates DEFAULT(CURRENT_TIMESTAMP) For dates);--这样便报错,求解
------解决方案--------------------
DROP TABLE Test;CREATE TABLE Test( dates DATE NOT NULL DEFAULT(CURRENT_TIMESTAMP));--这样可以 CREATE TABLE Test( dates DATE NOT NULL, CONSTRAINT DFT_dates DEFAULT(CURRENT_TIMESTAMP) For dates);--这样便报错,求解