To do that, add the INFORMATION_SCHEMA database to the Databases list defined within a database connection: Viewing the INFORMATION_SCHEMA database in Navicatīeing a system table, you won't be able to see the INFORMATION_SCHEMA database unless you explicitly tell Navicat to show it. In today's blog, we'll use the INFORMATION_SCHEMA database to find out whether or not a column exists and how many columns a particular table has. Regardless of how you refer to it, the INFORMATION_SCHEMA database is the ideal place to obtain details about table columns. It's also sometimes referred to as the data dictionary or system catalog. It contains database metadata, such as the names of databases, tables, the column data types, and even access privileges. Obtaining Meta-data about Database Table Columns by Robert GravelleĬertain relational databases, including MySQL and SQL Server, have an INFORMATION_SCHEMA system database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |