Top "Schema" questions

SQL statement to get column type

Is there a SQL statement that can return the type of a column in a table?

sql 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

Differences between INDEX, PRIMARY, UNIQUE, FULLTEXT in MySQL?

What are the differences between PRIMARY, UNIQUE, INDEX and FULLTEXT when creating MySQL tables? How would I use them?

mysql indexing key schema

Change Schema Name Of Table In SQL

I want to change schema name of table Employees in Database. In the current table Employees database schema name is …

sql sql-server tsql schema

XML Schema (XSD) validation tool?

At the office we are currently writing an application that will generate XML files against a schema that we were …

xml validation xsd schema

How to create a new schema/new user in Oracle Database 11g?

I have applied for an internship in a company and as a question they have asked me to create a …

sql database-design oracle11g schema database

How to define object in array in Mongoose schema correctly with 2d geo index

I'm currently having problems in creating a schema for the document below. The response from the server always returns the "…

node.js mongodb mongoose schema geo

What is the difference between a schema and a table and a database?

This is probably a n00blike (or worse) question. But I've always viewed a schema as a table definition in …

database schema definition database-table

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