Hello there
I am looking to extract tables name and primary keys of a database in order to use it on the other workspace
Any idea, please
I don't know if you want to automate this or just get a list, but databases usually include a system table that lists all user tables.
For example in SQL Server this command should return a list of tables:
SELECT TABLE_NAME FROM <DATABASE_NAME>.INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'
You could put that into FME in a SQLCreator transformer, and then you'll get a list of tables each as a separate FME feature.
I don't know what else is stored in that table, but I expect primary key would be another piece of available information.
22 votes
20 votes
19 votes
18 votes
17 votes
16 votes
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.