Get Database Table Name From Layer Name in ArcObjects

Question

I am using ArcObjects v10.0 with a SQL Server 2008 database. Given the name of a Layer, is there a way for me to extract the corresponding name of the database table that represents that Layer?

The Layer name and the Database Table name will often be identical, but they will not in cases where the Layer name contains invalid characters, such as spaces.

Answer 1

Here you go:

IFeatureLayer fl = ...;
string tablename = ((IDataset)fl.FeatureClass).BrowseName;

Link: IDataset.BrowseName API Docs

Answer 2

    public static string GetServerNameForLayer(ILayer pLayer)
    {
        try
        {
            if (pLayer == null) return "";
            ESRI.ArcGIS.Carto.IDataLayer pDataLayer = pLayer as IDataLayer; // QI 
            if (pDataLayer == null) return "";
            ESRI.ArcGIS.Geodatabase.IDatasetName pDatasetName = pDataLayer.DataSourceName as IDatasetName; ; // QI 
            if (pDatasetName == null) return "";
            ESRI.ArcGIS.Carto.IFeatureLayer pFeatLayer = pLayer as IFeatureLayer; // QI 
            if (pLayer == null) return "";
            ESRI.ArcGIS.Geodatabase.IDataset pDataset = pFeatLayer as IDataset; // QI 
            if (pDataset == null) return "";
            if (pDatasetName.WorkspaceName.Type == esriWorkspaceType.esriRemoteDatabaseWorkspace)
            {
                if (pDataset.Category == "SDE Feature Class")
                {
                    // Get the SERVER, DATABASE, USER, VERSION
                    ESRI.ArcGIS.esriSystem.IPropertySet2 pConnProps = pDataset.Workspace.ConnectionProperties as IPropertySet2;
                    return Convert.ToString(pConnProps.GetProperty("SERVER"));
                }
                return "";
            }               
            return "";
        }
        catch (Exception ex)
        {
            string strErrMsg = "ArcMapFeatureUtils::" + System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name;
            string crlf = "\r";
            strErrMsg = strErrMsg + " Error: " + ex.Message + crlf + ex.ToString() + crlf;
            //System.Windows.Forms.MessageBox.Show(strErrMsg, "Error");
            return "";
        }
    }