8 lines
255 B
MySQL
8 lines
255 B
MySQL
|
SELECT a.name, b.rows
|
||
|
|
FROM sysobjects AS a INNER JOIN
|
||
|
|
sysindexes AS b ON a.id = b.id
|
||
|
|
WHERE (a.type = 'u') AND (b.indid IN (0, 1))
|
||
|
|
ORDER BY b.rows DESC
|
||
|
|
|
||
|
|
|
||
|
|
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME='ORG_ID'
|