閱讀510 返回首頁    go 阿裏雲 go 技術社區[雲棲]

Sql_Server中如何判斷表中某列是否存在

/*判斷表AA中是否存在AA_ID這一列，如果不存在，則新增*/
IF NOT EXISTS (SELECT 1  FROM syscolumns INNER JOIN sysobjects ON sysobjects.id = syscolumns.id 
		WHERE syscolumns.name = 'AA_ID' AND sysobjects.name = 'AA')
ALTER TABLE AA ADD AA_ID VARCHAR(30) NULL   
GO

最後更新：2017-04-03 20:19:25

  上一篇：go linux係統下載 僅供學習測試
  下一篇：go Subqueries are not allowed in this context. Only scalar expressions are allowed.