SQLINFO – We play with data and technology

Today one of my colleague named  (Preethy kammath) asked about how to add a default value to a column using T-SQL. Since it was not in my memory, I took little time to search in the internet and I got the answer, i.e.

ALTER TABLE table_name ADD CONSTRAINT constraitn _name DEFAULT (value) for column_name

Thanks Preethy for refreshing my memory.