! CODEBANK 2012 !
İNDİRMEK&DETAYLI BİLGİ ALMAK İÇİN BURAYI TIKLAYINIZ.
ÖNEMLİ AÇIKLAMA: MUTLAKA OKUYUNUZ!
0 Üye ve 1 Ziyaretçi konuyu incelemekte.
SELECT DISTINCT RDB$RELATION_NAME FROM RDB$RELATION_FIELDS WHERE RDB$SYSTEM_FLAG=0;
SELECT RDB$RELATION_NAME FROM RDB$RELATIONS WHERE RDB$SYSTEM_FLAG=0;
SELECT DISTINCT RDB$RELATION_NAME FROM RDB$RELATION_FIELDS WHERE RDB$SYSTEM_FLAG=0 AND RDB$VIEW_CONTEXT IS NULL;-- yadaSELECT RDB$RELATION_NAME FROM RDB$RELATIONS WHERE RDB$SYSTEM_FLAG=0 AND RDB$VIEW_BLR IS NULL;
SELECT DISTINCT RDB$VIEW_NAME FROM RDB$VIEW_RELATIONS;-- sadece belli bir tablya ait görünüler içinSELECT DISTINCT RDB$VIEW_NAME FROM RDB$VIEW_RELATIONS WHERE RDB$RELATION_NAME='tabloAdi';
SELECT DISTINCT RDB$USER FROM RDB$USER_PRIVILEGES;
SELECT RDB$INDEX_NAME FROM RDB$INDICES WHERE RDB$RELATION_NAME='tabloadi' AND RDB$UNIQUE_FLAG IS NULL AND RDB$FOREIGN_KEY IS NULL;
SELECT RDB$INDEX_NAME FROM RDB$INDICES WHERE RDB$RELATION_NAME='tabloadi' AND ( RDB$UNIQUE_FLAG IS NOT NULL OR RDB$FOREIGN_KEY IS NOT NULL );
SELECT RDB$FIELD_NAME FROM RDB$RELATION_FIELDS WHERE RDB$RELATION_NAME='tabloadi';
tablo alan ve özelliklerini listelemek
SELECT RDB$FIELD_NAME AS alanadi, RDB$FIELD_POSITION AS alankonumu, RDB$DESCRIPTION AS alanaciklamasi, RDB$DEFAULT_VALUE AS alanvarsayılandegeri, RDB$NULL_FLAG AS alannotnullmi FROM RDB$RELATION_FIELDS WHERE RDB$RELATION_NAME='tabloadi';
SELECT RDB$GENERATOR_NAME FROM RDB$GENERATORS WHERE RDB$SYSTEM_FLAG IS NULL;
SELECT * FROM RDB$TRIGGERS WHERE RDB$SYSTEM_FLAG IS NULL;-- sadece verilen tablo içinSELECT * FROM RDB$TRIGGERS WHERE RDB$SYSTEM_FLAG IS NULL AND RDB$RELATION_NAME='tabloadi'
SELECT * FROM RDB$FUNCTIONS WHERE RDB$SYSTEM_FLAG IS NULL;
