https://community.esri.com/t5/file-geodatabase-api-questions/create-standalone-table-in-fgdb-using-api/m-p/1361897#M1231 <P>Yes, I was able to create a standalone table using the FGDB API. And it turns out the table is <U>not</U>&nbsp;registered with the geodatabase. But it can be registered with the GDB after the fact using the Register with Geodatabase geoprocessing tool.</P><P>Notes:</P><OL><LI>I used <U>SQL4Arc (Manifold)</U> add-in for ArcGIS Pro to create the table. SQL4Arc uses the FGDB API:<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Bud_0-1702874410106.png" style="width: 999px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/89326i766AF488CDB68BB1/image-size/large?v=v2&amp;px=999" role="button" title="Bud_0-1702874410106.png" alt="Bud_0-1702874410106.png" /></span></LI><LI><SPAN>I had trouble using <A href="https://sql4arc.com/doc/sql/changes_and_additions.htm#:~:text=DROP%20TABLE%20t%3B-,CREATE%20TABLE,-t%20(mfd_id%20INT64" target="_self">SQL to create a table</A> in SQL4Arc. The SQL would run without errors, but the table didn't show up in the FGDB in Catalog. So I used the UI in SQL4Arc instead to create the table. However, point #3 below might have been the culprit.</SPAN></LI><LI>I initially had trouble seeing standalone tables in SQL4Arc. The solution seemed to be to add a FC to the map in ArcGIS Pro. Once there was a FC in the map, then the standalone tables showed up in SQL4Arc too.</LI><LI>Related:<UL><LI>Esri Case 03506437 - ArcGIS Pro 3.2: How-to determine if an item is registered with a GDB or not ?</LI><LI>BUG-000163772: Views in file and mobile geodatabases do not indicate in their Data Source properties if they have been registered with the database</LI><LI><P>Video:<BR /><div class="lia-vid-container video-embed-center"><div id="lia-vid-6343426280112w854h540r125" class="lia-video-brightcove-player-container"><video-js data-video-id="6343426280112" data-account="6161463677001" data-player="default" data-embed="default" class="vjs-fluid" controls="" data-application-id="" style="width: 100%; height: 100%;"></video-js></div><script src="https://players.brightcove.net/6161463677001/default_default/index.min.js"></script><script>(function() { var wrapper = document.getElementById('lia-vid-6343426280112w854h540r125'); var videoEl = wrapper ? wrapper.querySelector('video-js') : null; if (videoEl) { if (window.videojs) { window.videojs(videoEl).ready(function() { this.on('loadedmetadata', function() { this.el().querySelectorAll('.vjs-load-progress div[data-start]').forEach(function(bar) { bar.setAttribute('role', 'presentation'); bar.setAttribute('aria-hidden', 'true'); }); }); }); } }})();</script><a class="video-embed-link" href="https://community.esri.com/t5/video/gallerypage/video-id/6343426280112">(view in My Videos)</a></div></P><P>&nbsp;</P></LI></UL></LI></OL> Mon, 18 Dec 2023 05:01:01 GMT Bud 2023-12-18T05:01:01Z https://community.esri.com/t5/file-geodatabase-api-questions/create-standalone-table-in-fgdb-using-api/m-p/1361422#M1229 <P>Is there a way to create a standalone table in a FGDB using the&nbsp;file geodatabase API?</P><P>If yes, does the table get automatically registered with the geodatabase? Or would we need to use the Register with Geodatabase geoprocessing tool after the fact?</P> Fri, 15 Dec 2023 15:41:58 GMT https://community.esri.com/t5/file-geodatabase-api-questions/create-standalone-table-in-fgdb-using-api/m-p/1361422#M1229 Bud 2023-12-15T15:41:58Z https://community.esri.com/t5/file-geodatabase-api-questions/create-standalone-table-in-fgdb-using-api/m-p/1361897#M1231 <P>Yes, I was able to create a standalone table using the FGDB API. And it turns out the table is <U>not</U>&nbsp;registered with the geodatabase. But it can be registered with the GDB after the fact using the Register with Geodatabase geoprocessing tool.</P><P>Notes:</P><OL><LI>I used <U>SQL4Arc (Manifold)</U> add-in for ArcGIS Pro to create the table. SQL4Arc uses the FGDB API:<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Bud_0-1702874410106.png" style="width: 999px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/89326i766AF488CDB68BB1/image-size/large?v=v2&amp;px=999" role="button" title="Bud_0-1702874410106.png" alt="Bud_0-1702874410106.png" /></span></LI><LI><SPAN>I had trouble using <A href="https://sql4arc.com/doc/sql/changes_and_additions.htm#:~:text=DROP%20TABLE%20t%3B-,CREATE%20TABLE,-t%20(mfd_id%20INT64" target="_self">SQL to create a table</A> in SQL4Arc. The SQL would run without errors, but the table didn't show up in the FGDB in Catalog. So I used the UI in SQL4Arc instead to create the table. However, point #3 below might have been the culprit.</SPAN></LI><LI>I initially had trouble seeing standalone tables in SQL4Arc. The solution seemed to be to add a FC to the map in ArcGIS Pro. Once there was a FC in the map, then the standalone tables showed up in SQL4Arc too.</LI><LI>Related:<UL><LI>Esri Case 03506437 - ArcGIS Pro 3.2: How-to determine if an item is registered with a GDB or not ?</LI><LI>BUG-000163772: Views in file and mobile geodatabases do not indicate in their Data Source properties if they have been registered with the database</LI><LI><P>Video:<BR /><div class="lia-vid-container video-embed-center"><div id="lia-vid-6343426280112w854h540r810" class="lia-video-brightcove-player-container"><video-js data-video-id="6343426280112" data-account="6161463677001" data-player="default" data-embed="default" class="vjs-fluid" controls="" data-application-id="" style="width: 100%; height: 100%;"></video-js></div><script src="https://players.brightcove.net/6161463677001/default_default/index.min.js"></script><script>(function() { var wrapper = document.getElementById('lia-vid-6343426280112w854h540r810'); var videoEl = wrapper ? wrapper.querySelector('video-js') : null; if (videoEl) { if (window.videojs) { window.videojs(videoEl).ready(function() { this.on('loadedmetadata', function() { this.el().querySelectorAll('.vjs-load-progress div[data-start]').forEach(function(bar) { bar.setAttribute('role', 'presentation'); bar.setAttribute('aria-hidden', 'true'); }); }); }); } }})();</script><a class="video-embed-link" href="https://community.esri.com/t5/video/gallerypage/video-id/6343426280112">(view in My Videos)</a></div></P><P>&nbsp;</P></LI></UL></LI></OL> Mon, 18 Dec 2023 05:01:01 GMT https://community.esri.com/t5/file-geodatabase-api-questions/create-standalone-table-in-fgdb-using-api/m-p/1361897#M1231 Bud 2023-12-18T05:01:01Z