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 get all columns' names for all the tables in MySQL?

Is there a fast way of getting all column names from all tables in MySQL, without having to list all …

mysql database-schema database-metadata
How to find column names for all tables in all databases in SQL Server

I want to find all column names in all tables in all databases. Is there a query that can do …

sql sql-server tsql sql-server-2000 database-schema
When to use MyISAM and InnoDB?

MyISAM is designed with the idea that your database is queried far more than its updated and as a result …

mysql database database-schema
How can I initialize a MySQL database with schema in a Docker container?

I am trying to create a container with a MySQL database and add a schema to these database. My current …

mysql docker database-schema
SQL Query to search schema of all tables

I am working on a SQL Server 2008 Db that has many tables in it (around 200). Many of these tables contain …

sql-server sql-server-2008 tsql database-schema
Differences between key, superkey, minimal superkey, candidate key and primary key

I'm new to MySQL, and I'm really confused about the different terms that I've encountered. I tried googling the answer …

key terminology database-schema
How do I set the default schema for a user in MySQL

Is there a way to set a default schema for each user in MySQL and if so how? Where user …

mysql default database-schema
List all stored procedures with schema name

Can anyone advise on a way to list all stored procedures along with their schema names in a database? Thanks!

sql-server-2008 stored-procedures database-schema
grant select on view

somewhere along the way something is going wrong, and I can't seem to find out why. If this is already …

oracle select database-schema grant