dql


DQL to find attribute's table


We can always find a respective table attribute from a table by syntax(select * from table_name), is there way to do the vise versa I mean is there any way to find tables name with attribute name?
Well, if by tables you mean objects, you can query the data dictionary:
select distinct type_name from dmi_dd_attr_info where attr_name = 'subject'
This will give you the names of all the types which have the attribute "subject"; distinct is needed because you have one entry for each {type, attribute, locale}, so you'll get many lines for the same attribute and type because of the different locales you might have installed.
If by table you mean registered tables, then it depends on whether you registered the tables with the real columns or not. If you did, then you can query the dm_registered objects:
select owner_name, table_name from dm_registered where any column_name = 'dummy'

Related Links

how to fetch the objects in dm_acl who grants the same sets of permission at the same time
Need a clarification on Auto Approval activity in documentum
count how many objects have been updated in Documentum
the fetched data from documentum (dm_acl Object Table) turns out to be null ? why?
Selecting N rows from each category DQL
the table is not registered or you do not have access to it (documentum)
DQL script for using order by clause to get case insensitive values
to calculate number of days between two dates in dql documentum
EMC Documentum DQL - How to delete repeating attribute
documentum dql return cabinets where r_accessor_permit > 2
Export the latest document to local machine
How to return cabinets not including hidden ones with DQL
Documentum DQL: Change user type
DQL query to find active users count
DQL: enable (return_top 10) performance impact
Symfony2 - Custom DQL function not found

Categories

HOME
shopify
freepascal
wmic
textwatcher
windows-7
vs-team-services
memory-leaks
deep-linking
tomcat7
couchdb-2.0
javamail
azureservicebus
sudo
height
unity2d
powershell-v3.0
hosts
derived
atlassian-plugin-sdk
primes
device-detection
header-files
rworldmap
continuous-deployment
widevine
reply
multichoiceitems
vertex-buffer
dd-wrt
hibernate-cache
getline
fabric-digits
recurrence-relation
large-data
hashcat
android-download-manager
coreclr
wcf-security
exiftool
stdclass
mediawiki-extensions
react-native-router-flux
pdftk
dojox.mobile
python-idle
dojox.grid.datagrid
lirc
recycle-bin
data-integration
jags
greenhills
photon-controller
fedora20
castle-dynamicproxy
sqlexception
onresume
sql-server-administration
android-navigationview
typhoon
cfeclipse
software-product-lines
visible
multifile-uploader
brython
contour
portfolio
zuora
consensus
utf-32
pgagent
rhel5
cocoascript
grunt-contrib-concat
google-admin-audit-api
log4cplus
alertifyjs
pic24
magic-numbers
dbsetup
openkinect
exiv2
sqljdbc
cdata
goinstant
prng
transitive-closure-table
socketstream
maven-ear-plugin
css-tables
die
signals2
v4l
ubuntu-11.04
throttling
ou
msbuildextensionpack
port-scanning
web-statistics
lazy-c++
configurable

Resources

Mobile Apps Dev
Database Users
javascript
java
csharp
php
android
MS Developer
developer works
python
ios
c
html
jquery
RDBMS discuss
Cloud Virtualization
Database Dev&Adm
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App