SQL queries all tables in the target database with their key information

1. Querying all tables in the target library

SELECTobj.name TableName,---table nameSchem.name Schemname,---the scheme to which the table belongsIdx.rows,---A total of several rows of arraysCAST(     Case  when(SELECT COUNT(1) fromSys.indexesWHERE object_id=Obj.object_id  andIs_primary_key=1)>=1      Then 1    ELSE 0    END  as BIT) HasPrimaryKey---whether the table has a primary key fromZC_UAC.sys.objects objINNER JOINZC_UAC.dbo.sysindexes idx onObj.object_id=Idx.id andIdx.indid<=1 INNER JOINZC_UAC.sys.schemas Schem onobj.schema_id=schem.schema_idwhereTypeinch('U')Order  byObj.name

2. Querying all tables and views in the target library

SELECTobj.name TableName,---table nameSchem.name Schemname,---the scheme to which the table belongsCAST(     Case  when(SELECT COUNT(1) fromSys.indexesWHERE object_id=Obj.object_id  andIs_primary_key=1)>=1      Then 1    ELSE 0    END  as BIT) HasPrimaryKey---whether the table has a primary key fromZC_UAC.sys.objects objINNER JOINZC_UAC.sys.schemas Schem onobj.schema_id=schem.schema_idwhereTypeinch('U','V')Order  byObj.name

SQL queries all tables in the target database with their key information