All tables rowcount - Veritabanini yormadan rowcount cekme-metadata
Definition Description
USE AtlantisDB GO SELECT t.TABLE_SCHEMA,o.NAME AS TabloAdi, i.rowcnt AS KayitSayisi FROM sysindexes AS i INNER JOIN sysobjects AS o ON i.id = o.id INNER JOIN INFORMATION_SCHEMA.TABLES T ON T.TABLE_NAME=o.name WHERE i.indid < 2 AND OBJECTPROPERTY(o.id, 'IsMSShipped') = 0 AND i.rowcnt >100000000 AND o.name NOT LIKE 'Temp_%' AND o.xtype !='TF' ORDER BY o.name ASC
-- orjinal sorgu SELECT o.NAME AS TabloAdi, i.rowcnt AS KayitSayisi FROM sysindexes AS i INNER JOIN sysobjects AS o ON i.id = o.id WHERE i.indid < 2 AND OBJECTPROPERTY(o.id,'IsMSShipped') = 0 ORDER BY i.rowcnt DESC
