21-10-12, 04:48 PM
كاتب الموضوع : BADRMEDIA
أحياناً نحتاج لنعرف أسماء الجداول فى قاعدة البيانات بجانب عدد السجلات فى كل جدول كود :
[COLOR=#000000][COLOR=#0000bb]SELECT
[/COLOR][color=#007700][[/color][color=#0000bb]TableName[/color][color=#007700]] = [/color][color=#0000bb]so[/color][color=#007700].[/color][color=#0000bb]name[/color][COLOR=#007700],
[[/COLOR][color=#0000bb]RowCount[/color][color=#007700]] = [/color][color=#0000bb]MAX[/color][color=#007700]([/color][color=#0000bb]si[/color][color=#007700].[/color][color=#0000bb]rows[/color][COLOR=#007700])
[/COLOR][COLOR=#0000bb]FROM
sysobjects so[/COLOR][COLOR=#007700],
[/COLOR][COLOR=#0000bb]sysindexes si
WHERE
so[/COLOR][color=#007700].[/color][color=#0000bb]xtype [/color][color=#007700]= [/color][COLOR=#dd0000]'U'
[/COLOR][COLOR=#007700]AND
[/COLOR][color=#0000bb]si[/color][color=#007700].[/color][color=#0000bb]id [/color][color=#007700]= [/color][color=#0000bb]OBJECT_ID[/color][color=#007700]([/color][color=#0000bb]so[/color][color=#007700].[/color][color=#0000bb]name[/color][COLOR=#007700])
[/COLOR][COLOR=#0000bb]GROUP BY
so[/COLOR][color=#007700].[/color][COLOR=#0000bb]name
ORDER BY
2 DESC
[/COLOR][/COLOR]