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.
27 votes
26 votes
23 votes
21 votes
15 votes
13 votes
11 votes
10 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.