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
45
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
53
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
330
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
528
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
312
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
845
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