Questions tagged [information-schema]
information schema : ODBC standard Views of RDBMS MetaData
148 questions
0 votes
1 answer
84 views
Can db_datareader query INFORMATION_SCHEMA?
Microsoft documentation says about db_datareader role that: db_datareader: Members of the db_datareader fixed database role can read all data from all user tables and views. User objects can exist in ...
0 votes
1 answer
43 views
Same global user works local but fails on live server for information_schema database UPDATE query
I have two database servers, local and live. The local server is running MariaDB 10.11.6, the live server is running 10.11.8. I have the exact same global user, example@localhost on both the local and ...
- 769
0 votes
1 answer
52 views
Aurora3 RDS MySQL Stored function/trigger performance when using information_schema
Since moving to Aurora3 RDS (MySQL 8 based) vs Aurora 2 (MySQL 5.7 based) noticed that execution time of certain triggers and stored functions performance has degraded. Correlation between triggers ...
0 votes
0 answers
329 views
INFORMATION_SCHEMA tables take so long when used in certain ways
While attempting to find better ways to parse table schema data, the INFORMATION_SCHEMA articles were tested. There must be way more going on behind the scenes then meets the eye. Using sys.* articles,...
- 683
0 votes
0 answers
527 views
Remove not existing table from MySQL INFORMATION_SCHEMA
I removed (dropped) not used (in fact it was corrupted and that's why not used) table from a MySQL DB. I did it from MySQL Workbench. It was removed and it's not existing here. mysql> SELECT * FROM ...
- 13
0 votes
1 answer
309 views
column size differing when querying from all_tab_columns
We create a table as follows: CREATE TABLE "CHANGEWORKFLOWREQUEST" ( "DATA" CLOB CONSTRAINT "ChangeWorkflowRequest_data" CHECK ("DATA" IS JSON FORMAT JSON) ...
- 189
0 votes
2 answers
842 views
How to display name and type of table columns in creation order?
I have created this tbl_cities using the code below: CREATE TABLE IF NOT EXISTS public.tbl_Cities (City_ID SERIAL NOT NULL, City_Name VARCHAR(100) NOT NULL, City_State_Region VARCHAR(100), ...
- 125
0 votes
1 answer
1k views
MariaDB privileges for "SHOW DATABASES" vs "SELECT * FROM information_schema"
I have a user with an access to several databases. In MariaDB 10.6.11 I cannot use the following command to list all accessible databases: SHOW DATABASES; /* SQL Error (1227): Access denied; you need (...
- 23
0 votes
1 answer
41 views
I need advice for which database system to use
I have to create a database from scratch for the first time and I am not sure which system I should try. I will have specific IP addresses, IP ranges, domain names, host names which will be the key ...
- 11
0 votes
1 answer
53 views
How to Design Schema for Many To Many for a single Table
What is the right way to design schema for self Nested or many to many relationship for single Table Table:Products id name status Need to Match/save Products with related Products. ex: Related ...
0 votes
1 answer
237 views
Unable to find variable : mysql-monitor_username in global_variables table in information_schema database in MySQL
I am trying to perform the initial configuration in proxysql and I found that while doing the Configure monitoring, I am unable to find the variable mysql-monitor_username in the global_variables ...
- 21
-3 votes
1 answer
257 views
Fastest way to query column names from a table
I am looking for the fastest way to query the a list of columns from a given table in a database. I realize the INFORMATION_SCHEMA.columns view exists in Microsoft SQL Server. However, in PostgreSQL, ...
1 vote
1 answer
4k views
MYSQL 8.0.2.8 Information_schema character set is incorrect, and I cannot find where to change it
I have a database installation where the collations look as so: As you can see, all the databases are utf8mb4, while the information schema is showing up as utf8mb3. This is causing me issues as I ...
- 11
1 vote
2 answers
1k views
MySQL information.schema.tables shows create_time later than update_time?
I've checked the documentation, but couldn't find anything that could explain this. mysql> SELECT * FROM information_schema.`TABLES` WHERE table_schema='myschema' AND TABLE_NAME ='mytable' \G; *****...
- 145
1 vote
1 answer
4k views
How is the information_schema table in trino updated?
We use Trino (https://trino.io/) to connect to HDFS. I discovered that the data in the information_schema tables, for example: select * from information_schema.columns clz where clz....
- 244