In Oracle [ALL_INDEXES] contains a column named [GENERATED] which specifies whether or not that index is created by system.
However, I can not find same method for sql server and postgres.
Asked
Active
Viewed 52 times
1
Alexander Farber
- 21,519
- 75
- 241
- 416
Quang Duy
- 23
- 3
-
Check this out [indexed in mysql](http://stackoverflow.com/questions/5213339/how-to-see-indexes-for-a-database-or-table) – Tariq Albajjali Oct 21 '16 at 08:01
-
There is no such property for Postgres. You can't distinguish the system generated names from the user supplied names. – Oct 21 '16 at 08:08
-
In case of postgresql, index is created by system generally start from **pg_** but I am not sure. – Nikhil Oct 21 '16 at 19:12