database-schema Questions
4
somewhere along the way something is going wrong, and I can't seem to find out why. If this is already asked apologies.
I have 3 schema's in my database:
COLLDESK
LOCAL_IT
GERBEN
COLLDESK is our ...
Byzantium asked 19/6, 2014 at 13:31
11
Solved
Is there a fast way of getting all column names from all tables in MySQL, without having to list all the tables?
Drawers asked 13/4, 2011 at 11:27
7
Solved
I have a PostgreSQL database for my Rails application. In the schema named 'public' the main Rails models tables are stored etc. I have created a 'discogs' schema which will have tables with names ...
Finella asked 10/1, 2012 at 15:59
8
Solved
I have a very large Oracle database, with many many tables and millions of rows. I need to delete one of them, but want to make sure that dropping it will not break any other dependent rows that po...
Jiujitsu asked 24/3, 2010 at 16:36
1
I am surprised why this is so hard to find.
I am trying to convert my monolith to a 3 layer architecture for my node express app with a propriety sql.
Repository
BEFORE architecture change
1 fi...
Alexandrina asked 24/3, 2020 at 19:17
7
Solved
In mongodb docs the author mentions it's a good idea to shorten property names:
Use shorter field names.
and in an old blog post from how to node (it is offline by now April, 2022 edit)
....oft-...
Beady asked 8/10, 2012 at 23:25
3
I created some sqlite tables schema using python.
When I use the sqlite3 client and issue the .schema command, I can see the output is pre-formated as in the SQL source file I used as argument for...
Careful asked 7/7, 2016 at 22:6
2
Solved
Having the capability to compute a UTC timestamp as the default value for a column is a handy feature of most popular database solutions. Does Google Cloud Spanner support this? If not, is this a p...
Tandem asked 7/3, 2017 at 19:20
4
Solved
I searched throughout the net and have not been able to determine how to add a schema to this sequelize model below. The following code does not kick back errors, however when I inspect the postgre...
Hylton asked 27/2, 2017 at 22:51
9
I've made a whole bunch of changes on my development machine (table definitions, stored procedures etc). It there a script or a free tool I can run which will find all the differences between...
Nalley asked 22/12, 2010 at 9:56
10
Solved
Is there a difference between a schema and a database in MySQL? In SQL Server, a database is a higher level container in relation to a schema.
I read that Create Schema and Create Database do esse...
Selfassured asked 23/7, 2012 at 18:26
14
Solved
How do I see if my database has any indexes on it?
How about for a specific table?
Charente asked 6/3, 2011 at 20:55
0
I have data that looks like this
PersonJSONData = {
"key1": {
"name": "odo",
"age": 10,
"favorites": {
"food": ["rice", &q...
Tourmaline asked 28/1, 2022 at 9:36
7
Solved
I've been searching around and the question was asked a few times, but no-one seem to be able to give a definite answer to it. How do you specify the integer length for the table column using Schem...
Permeability asked 10/9, 2014 at 18:42
2
Solved
I know how to set the schema for a table in my context but is there a way to set the default schema for all the tables in a context?
i.e.
[Schema = "Ordering"]
public class MyContext:DbContext
{...
Nordgren asked 28/5, 2015 at 16:29
3
Solved
I am new to JPA, I have created a class like the following
/**
*
*/
package programme;
import javax.persistence.Access;
import javax.persistence.AccessType;
import javax.persistence.Entity;
im...
Adaxial asked 27/4, 2014 at 17:16
2
I'm about to build a Node.js+Express+Mongoose app and I'd like to pick the community's brains and get some advice on best practices and going about creating an efficient schema design.
My applicat...
Shetrit asked 24/5, 2016 at 3:55
3
Solved
Is there a way to grant all privileges to a user on Oracle schema? I tried the following command but it only grants permission on specific tables in a schema. What I want is to give this user all p...
Hydrastis asked 8/12, 2014 at 7:55
6
Solved
I'm trying to do this, but it seems like MySQL isn't allowing me. Is there a solution to this issue or am I expected to always include the function in my INSERT queries?
CREATE TABLE foo(
created...
Humanist asked 16/3, 2011 at 19:56
11
Solved
I am trying to create a container with a MySQL database and add a schema to these database.
My current Dockerfile is:
FROM mysql
MAINTAINER (me) <email>
# Copy the database schema to the /...
Gribble asked 19/3, 2015 at 13:4
7
Solved
Consider this table:
+-------+-------+-------+-------+
| name |hobby1 |hobby2 |hobby3 |
+-------+-------+-------+-------+
| kris | ball | swim | dance |
| james | eat | sing | sleep |
| ...
Endarch asked 3/10, 2011 at 9:20
1
Solved
I'm trying to make two 1:1 relations in one model in Prisma ORM, but got following error:
Error validating model "Person": Ambiguous relation detected. The fields placeOfBirth and placeO...
Conductivity asked 6/5, 2021 at 5:29
11
Solved
UPD here is the way I solved the problem. Although it's likely to be not the best one, it worked for me.
I have an issue with working with EF Core. I want to separate data for different companie...
Landfall asked 14/9, 2016 at 20:52
5
Solved
I am trying to query my database. Some records currently have extra fields that are not included in my model schema (by error, but I want to handle these cases). When I try to query the DB and tran...
Personify asked 7/4, 2015 at 15:14
14
Solved
I'm just looking for a simple query to select all the table names for a given schema.
For example, our DB has over 100 tables and I need to find any table that contains the sub-string “CUR”. I can...
Jeromejeromy asked 27/8, 2010 at 12:12
© 2022 - 2025 — McMap. All rights reserved.