Top "Database-schema" questions

A description of the structure of the database - including the structure of the tables, columns, constraints, views, etc, etc.

How to see indexes for a database or table in MySQL?

How do I see if my database has any indexes on it? How about for a specific table?

mysql indexing database-schema
How do I show the schema of a table in a MySQL database?

From the MySQL console, what command displays the schema of any given table?

mysql database schema database-schema
How to rollback a specific migration?

I have the following migration file db\migrate\20100905201547_create_blocks.rb How can I specifically rollback that migration file?

ruby-on-rails schema database-schema rollback
How to store arrays in MySQL?

I have two tables in MySQL. Table Person has the following columns: id | name | fruits The fruits column may hold …

mysql database-schema
What are OLTP and OLAP. What is the difference between them?

Actually what do they mean? All articles I find about them don't give me an idea, or my knowledge is …

database database-design database-schema olap oltp
DB2 Query to retrieve all table names for a given schema

I'm just looking for a simple query to select all the table names for a given schema. For example, our …

sql db2 database-schema
How to SELECT in Oracle using a DBLINK located in a different schema?

We have an Oracle DBMS (11g) and the following configuration: A DB user "MYUSER" Two schemas "MYUSER" and "SCHEMA_B" …

database oracle database-schema dblink
How to fix Error: "Could not find schema information for the attribute/element" by creating schema

I have a windows forms application written in VS2010 with C# and get the following errors in the app.config …

c# error-handling database-schema application-settings
Difference Between Schema / Database in MySQL

Is there a difference between a schema and a database in MySQL? In SQL Server, a database is a higher …

mysql database schema database-schema
Difference between database and schema

What's the difference between a Database and a Schema in SQL Server? Both are the containers of tables and data. …

sql-server database sql-server-2005 database-schema