检查表中是否存在列
如何使用SQL查询检查表中是否存在列? 我正在使用Access 2007。
您可以使用Information_schema视图:
If Not Exists (Select Column_Name
From INFORMATION_SCHEMA.COLUMNS
Where Table_Name = 'YourTable'
And Column_Name = 'YourColumn')
begin
-- Column doesn't exist
end
另外,您可能希望通过包含数据库和/或模式来进一步限制where
子句。
If Not Exists (Select Column_Name
From INFORMATION_SCHEMA.COLUMNS
Where Table_Name = 'YourTable'
And Column_Name = 'YourColumn'
And Table_Catalog = 'YourDatabaseName'
And Table_Schema = 'YourSchemaName')
begin
-- Column doesn't exist
end
if Exists(select * from sys.columns where Name = N'columnName'
and Object_ID = Object_ID(N'tableName'))
begin
-- Column Exists
end
“参考”
IF NOT EXISTS (SELECT 1
FROM syscolumns sc
JOIN sysobjects so
ON sc.id = so.id
WHERE so.Name = 'TableName'
AND sc.Name = 'ColumnName')
BEGIN
--- do your stuff
END
链接地址: http://www.djcxy.com/p/94415.html
上一篇: Check Column Exist in a Table
下一篇: SQL Server : check if table column exists and remove rows