摘要： 查询某表的所有字段select name from syscolumns where id = object_id(N'[dbo].[表名]') and OBJECTPROPERTY(id, N'IsUserTable') = 1查询某表是否包含某字段if exists (Select * from syscolumns Where Name='[字段名]' And ID=OBJECT_ID('[表名]')) print '有这个字段'在现有的表中增加字段：Sql="alter table [表名] ad 阅读全文