database-schema Questions
8
Solved
I have a database with schema public and schema_A. I need to create a new schema schema_b with the same structure than schema_a.
I found the function below, the problem is that it does not copy th...
Sleepyhead asked 13/8, 2013 at 18:25
17
Solved
I want to find all column names in all tables in all databases. Is there a query that can do that for me?
Iow asked 28/4, 2010 at 11:53
11
Solved
Is it possible, using mysql dump to export the entire database structure, but exclude certain tables data from export.
Say the database has 200 tables, I wish to export the structure of all 200 ta...
Compliment asked 27/11, 2012 at 21:12
4
Solved
I use Visual Studio 2013 Professional Update 4 in combination with multiple SQL Server 2012 Enterprise servers/instances. The Idea was to create a Version controlled deployment using a Visual Studi...
Osmose asked 26/3, 2015 at 11:33
7
I am working on a python script that is designed to process some data, create a table if not exists, and truncate the table before inserting a refreshed dataset. I am using a role that has usage, r...
Halfway asked 2/3, 2021 at 0:27
9
Solved
I'm just getting started learning SQLite. It would be nice to be able to see the details for a table, like MySQL's DESCRIBE [table]. PRAGMA table_info [table] isn't good enough, as it only has basi...
Lainelainey asked 25/7, 2010 at 18:23
4
If I have a table in Postgresql:
create table Education (
id integer references Profiles(id),
finished YearValue not null,
started YearValue,
qualification text,
schoolName text,
studiedAt ...
Felicefelicia asked 27/3, 2011 at 7:47
6
How to import and export schema from Cassandra or Cassandra cqlsh prompt?
Sheila asked 8/5, 2013 at 12:24
11
My computer broke down but fortunately I backed up
the folder C:\Program Files\PostgreSQL.
Now I'm working in a new computer and I would like to import the previous
Postgres databases that are st...
Validity asked 23/1, 2013 at 17:57
10
Solved
Is it possible? Can i specify it on the connection URL? How to do that?
Capernaum asked 12/11, 2010 at 20:15
6
Solved
I'm trying to create a backup from PostgreSQL database, but getting the following error: pg_dump: No matching schemas were found
I'm logged in as root and running the command
pg_dump -f db.dump ...
Betweenwhiles asked 26/9, 2012 at 10:18
19
Solved
What SQL can be used to list the tables, and the rows within those tables in an SQLite database file – once I have attached it with the ATTACH command on the sqlite3 command line tool?
Cake asked 17/9, 2008 at 12:59
16
Solved
I'm using a MySql database with a Java program, now I want to give the program to somebody else.
How to export the MySQL database structure without the data in it, just the structure?
Stelu asked 30/5, 2011 at 11:6
3
Solved
I am working on a database which has some types (e.g. User, Appointment, Task etc.) which can have zero or more Notes associated with each type.
The possible solutions I have come across for imple...
Hobbledehoy asked 23/6, 2019 at 19:8
5
Solved
Recently we were having issues on our database server and after long efforts it was decided to change the database server. So we managed to restore the database on another server, change the connec...
Fehr asked 10/7, 2013 at 12:56
2
How to fetch a list of schema from the current database. The result which we get using \dn. This query fetches all schema
SELECT table_schema,table_name
FROM information_schema.tables
ORDER BY ...
Myth asked 24/5, 2018 at 12:49
6
Solved
Basically I want to get the table names, and the field names for each table from the current database that is connected, nothing else.
Is this possible?
I know that SHOW TABLES FROM my_database g...
Relive asked 7/12, 2011 at 19:24
20
Solved
I have the migration file db\migrate\20100905201547_create_blocks.rb.
How can I specifically rollback that migration file?
Calciferous asked 5/9, 2010 at 20:30
4
I've been trying to solve this one all week, help very much appreciated.
I have various schemas in a postgres db and I would like to be able to map to them from within the same or across different...
Handcraft asked 12/6, 2018 at 14:33
31
Solved
Is there a way using SQL to list all foreign keys for a given table? I know the table name / schema and I can plug that in.
Ad asked 20/7, 2009 at 8:14
6
How can I set a unique constraints on two columns?
class MyModel extends Migration {
public function up()
{
Schema::create('storage_trackers', function(Blueprint $table) {
$table->incremen...
Spiegleman asked 19/11, 2013 at 7:33
3
We have an Oracle DBMS (11g) and the following configuration:
A DB user "MYUSER"
Two schemas "MYUSER" and "SCHEMA_B"
User "MYUSER" can access "SCHEMA_B" and has READ permissions on its tables
A p...
Albuminate asked 27/9, 2012 at 14:57
3
Solved
I want to get table names ordered by it's dependency order.
For example: If I have table users, users_orders and orders I want to get table names this order: users (or orders does not matter), ord...
Brittani asked 27/6, 2017 at 15:46
4
Solved
Is it possible to replicate a single table?
Row asked 3/6, 2010 at 1:4
3
Solved
How to create a schema for spark from a trait?
Considering a trait:
trait A{
val name:String
val size:String
}
As :
Encoders.product[A].schema
gives:
Error:type arguments do not conform to method...
Leahy asked 9/10, 2020 at 9:4
1 Next >
© 2022 - 2025 — McMap. All rights reserved.