Friday, June 28, 2013 Tip of the Day: Displaying R:BASE Keys/Indexes Product: R:BASE eXtreme 9.5 (32/64) Build..: 9.5.3.20611 or higher www.rupdates.com Section: Data Dictionary (F3) Key
Using R:BASE eXtreme 9.5 (32/64), while in Data Designer (RBDefine), the [Key/Indexes] option allows users to create table constraints; such as Primary Keys, Foreign Keys and Unique Keys. Users can also create Indexes, which provide faster data retrieval for the database. Did you know that you can retrieve and display a complete list of Keys and Indexes, if defined, using the Data Dictionary (F3) key? Among many other database and non-database information, the enhanced Data Dictionary (F3) key in R:BASE eXtreme 9.5 (32/64), also includes a tab for [Keys/Indexes]. Selecting [Keys/Indexes] tab will list all database Keys and Indexes, if defined. By default, all Keys and Indexes are displayed including details such as, ID, Type, Table Name, and References. Clicking on the appropriate column header will sort the column in ascending and descending order accordingly. However, if you wish to only display Primary Keys, Unique Keys, Indexes, or Foreign Keys, you may use the Type: Drop-Down Filter option located above the columns to specifically display your selected option of Primary Keys, Unique Keys, Indexes, or Foreign Keys, if you wish. All: http://www.razzak.com/tips/RBG95_DataDictionary_All.jpg PKs: http://www.razzak.com/tips/RBG95_DataDictionary_PKs.jpg UKs: http://www.razzak.com/tips/RBG95_DataDictionary_UKs.jpg Ind: http://www.razzak.com/tips/RBG95_DataDictionary_Indexes.jpg FKs: http://www.razzak.com/tips/RBG95_DataDictionary_FKs.jpg R:BASE eXtreme 9.5 (32/64) Data Dictionary [F3] key includes the following options: . Databases . Tables . Columns . Keys/Indexes . Variables . Views . Forms . Reports . Labels . Functions . Stored Procedures . System Tables . System Columns . Themes . Printers . External Forms. . Applications . Colors . Control Types . Database Settings . Files While in Form Designer, the Data Dictionary includes the following additional tabs: . Form Component IDs . Form Actions While in Report Designer, the Data Dictionary includes the following additional tab: . Report Component IDs While in Label Designer, the Data Dictionary includes the following additional tab: . Label Component IDs While in External Form Designer, the Data Dictionary includes the following additional tabs: . External Form Component IDs . External Form Actions Enjoy the showcase and pride of our eXpanded R:Dream Team and stay productive, my friends! Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase www.RazzakMemon.com -- 30+ years of continuous innovation! 15 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
