3

What is the need for information_schema catalog views as they provide details which is same as (sys.objects and sys.columns).

information_schema.tables----->retrives from sys.objects.
information_schema.column----->retrives from sys.columns.
billinkc
  • 59,250
  • 9
  • 102
  • 159
SVS
  • 103
  • 7

1 Answers1

4

information_schema... are ANSI compatible views, other RDBMS systems also have these views, like MySQL, postgreSQL, SQLite . sys.columns only exist in SQL Server

PostgreSQL: http://www.postgresql.org/docs/current/interactive/information-schema.html

MySQL: http://dev.mysql.com/doc/refman/5.7/en/information-schema.html

SQLite : http://www.sqlite.org/cvstrac/wiki?p=InformationSchema

Oracle on the other hand does NOT have these views but their own versions like ALL_TABLES and ALL_TAB_COLUMNS

iruvar
  • 22,736
  • 7
  • 53
  • 82
SQLMenace
  • 132,095
  • 25
  • 206
  • 225
  • Please do you think you could take a look at this question : http://stackoverflow.com/questions/40197865/mssql-is-there-any-performance-penalty-for-wrapping-a-select-query-in-a-transa – eddy Oct 22 '16 at 23:35
  • SQLite does not have information_schema in 2019. It's very likely it wasn't available back in 2013 also. – joedotnot Oct 14 '19 at 10:43