MkyTaP - 開發筆記
主要工具: Linux, Python, SQL
Wednesday, May 9, 2018
SQL: 對table新增一個欄位並設定預設值
ALTER TABLE ptMapper ADD remark NVARCHAR(200)
ALTER TABLE ptMapper ADD CONSTRAINT DF_ptMapper_remark DEFAULT ('') FOR remark
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment