如何从数据库查询各表中所有存在默认值的字段答:-- tableName表名,sqlName列名,defaultVal就是默认值,字符串表示SELECT a.colorder as colOrder, d.name as tableName,a.name as sqlName, convert(int,case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then 1 else 0 end) as isIndex, convert(int,case when exists(SELECT 1 FROM...