有爱的天空，处处都是暖阳阳的。

摘要： 方法1：declare @objid int,@objname char(40)set @objname = 'tablename'select @objid = id from sysobjects where id = object_id(@objname)select 'Column_name' = name from syscolumns where id = @objid order by colid方法2：select Name from syscolumns where id=object_id( 'DataBaseName.TableNa 阅读全文