数据库结构比较的SQL 语句

数据库结构比较的SQL 语句

SQL SERVER

chk_collist_mssql

select sysobjects.name + '.' +  syscolumns.name , systypes.name ,
syscolumns.length ,
   CASE syscolumns.isnullable
      WHEN 1 THEN 'Y'
      WHEN 0 THEN 'N'
        END
from sysobjects , syscolumns ,systypes
where sysobjects.xtype ='U' and
sysobjects.id= syscolumns.id and
systypes.xtype = syscolumns.xtype
order by sysobjects.name ,  syscolumns.name ;

================================================

chk_cons_mssql

SELECT DISTINCT
      convert(varchar(30),sysobjects_1.name) AS TABLE_NAME,
      convert(varchar(30),syscolumns.name) AS COLUMN_NAME,
      sysindexkeys.keyno AS POSIT