find FC belongs to which Dataset

[HaniuHokkaido]

Dear experts,

How can I find a featureclass belongs to which dataset using SQL Query ?
I saw an example long time ago but i cant find it again now...

thanks

[VinceAngelo]

Using what version of ArcGIS?  The methodology changed at 10.0.

- V

[HaniuHokkaido]

I am using version 10.1..

I just found this link (for 10.1): http://resources.arcgis.com/en/help/main/10.1/index.html#//006z000000tv000000
and this (for 9.3) : http://forums.arcgis.com/threads/26666-join-GDB_FEATUREDATASET-and-SDE_layers
SELECT sde.GDB_OBJECTCLASSES.*, sde.GDB_FEATUREDATASET.Name AS FD_Name
FROM sde.GDB_OBJECTCLASSES LEFT OUTER JOIN
sde.GDB_FEATUREDATASET ON sde.GDB_OBJECTCLASSES.DatasetID = sde.GDB_FEATUREDATASET.ID

are they correct ?

Thanks