1、查询目标库中的所有表

SELECTobj.name tablename, ---表名schem.name schemname,  ---表所属的方案idx.rows,  ---一共有几行数组CAST(    CASE WHEN (SELECT COUNT(1) FROM sys.indexes WHERE object_id= obj.OBJECT_ID AND is_primary_key=1) >=1     THEN 1    ELSE 0    END AS BIT) HasPrimaryKey  ---表是否有主键from ZC_UAC.sys.objects obj INNER JOINZC_UAC.dbo.sysindexes idx ON obj.object_id=idx.id and idx.indid<=1 INNER JOINZC_UAC.sys.schemas schem ON obj.schema_id=schem.schema_idwhere type in('U')order by obj.name

 

2、查询目标库中所有的表和视图

SELECTobj.name tablename, ---表名schem.name schemname,  ---表所属的方案CAST(    CASE WHEN (SELECT COUNT(1) FROM sys.indexes WHERE object_id= obj.OBJECT_ID AND is_primary_key=1) >=1     THEN 1    ELSE 0    END AS BIT) HasPrimaryKey  ---表是否有主键from ZC_UAC.sys.objects obj INNER JOINZC_UAC.sys.schemas schem ON obj.schema_id=schem.schema_idwhere type in('U','V')order by obj.name