Посмотреть индексы в базе - История изменений

Aleksnick в 13:00, 18 мая 2016

2016-05-18T13:00:57Z

Aleksnick в 12:53, 18 мая 2016

2016-05-18T12:53:19Z

Aleksnick: Новая страница: «Процедура

 SET TERM ^ ;  create or alter procedure PR_GET_COUNT_TABLE_RECORDS returns (     TABLE_NAME DM_TEXT,     NAME DM_TEXT,     INACTIVE_STATU…»

2016-05-18T12:51:19Z

Новая страница: «Процедура <pre> SET TERM ^ ; create or alter procedure PR_GET_COUNT_TABLE_RECORDS returns ( TABLE_NAME DM_TEXT, NAME DM_TEXT, INACTIVE_STATU…»

Новая страница

Процедура
<pre>
SET TERM ^ ;

create or alter procedure PR_GET_COUNT_TABLE_RECORDS
returns (
TABLE_NAME DM_TEXT,
NAME DM_TEXT,
INACTIVE_STATUS DM_ID_NULL)
as
begin

for select R.RDB$RELATION_NAME
from RDB$RELATIONS R
where 1 = 1
and R.RDB$RELATION_NAME not starting with 'VW_'
and R.RDB$RELATION_NAME not starting with 'RDB$'
and R.RDB$RELATION_NAME not starting with 'MON$'
order by R.RDB$RELATION_NAME asc
into :table_name
do
begin
for select I.RDB$INDEX_NAME,
I.RDB$INDEX_INACTIVE
from RDB$INDICES I
where 1 = 1
and I.RDB$RELATION_NAME = :table_name
order by I.RDB$INDEX_NAME asc
into :NAME,
:inactive_status
do
suspend;
end

end^

SET TERM ; ^

/* Existing privileges on this procedure */

GRANT EXECUTE ON PROCEDURE PR_GET_COUNT_TABLE_RECORDS TO SYSDBA;
</pre>

@@ Строка 18: / Строка 18: @@
             and R.RDB$RELATION_NAME not starting with 'MON$'
       order by R.RDB$RELATION_NAME asc
-      into :table_name
+      into :TABLE_NAME
   do
   begin
    for select I.RDB$INDEX_NAME,
               I.RDB$INDEX_INACTIVE
        from RDB$INDICES I
        where 1 = 1
-             and I.RDB$RELATION_NAME = :table_name
+             and I.RDB$RELATION_NAME = :TABLE_NAME
        order by I.RDB$INDEX_NAME asc
        into :NAME,
-            :inactive_status
+            :UNIQUE_STATUS,
    do
     suspend;

@@ Строка 3: / Строка 3: @@
 SET TERM ^ ;
-create or alter procedure PR_GET_COUNT_TABLE_RECORDS
+create or alter procedure PR_GET_INDICES_LIST
 returns (
      TABLE_NAME DM_TEXT,
@@ Строка 39: / Строка 39: @@
 /* Existing privileges on this procedure */
-GRANT EXECUTE ON PROCEDURE PR_GET_COUNT_TABLE_RECORDS TO SYSDBA;
+GRANT EXECUTE ON PROCEDURE PR_GET_INDICES_LIST TO SYSDBA;
 </pre>