In (Som, Ni, Yak)
ALTER TABLE <table name>
ADD CONSTRAINT <constraint name>
FOR <column name>
quote:And how do I set it when designing the table?, I wrote getdate() in "Default value or binding" and I got an error message.
CREATE TABLE <table name>
<column name> datetime DEFAULT getdate()
quote:By the way, how do I set your answer as the correct answer as in other forums?
Flowing Fount of Yak Knowledge