General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2008 Server
As per Naomi's second suggestion, simply replace DatabaseName (lines 2 and 5) and Desired_FieldName (line 6) in the following query:
SELECT ObjectName AS TableName ;
FROM DatabaseName ;
WHERE ObjectID IN ( ;
SELECT ParentID ;
FROM DatabaseName ;
WHERE ObjectType = "Field" AND ObjectName = 'Desired_FieldName') ;
ORDER BY TableName
Mike
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only