Top "Schema" questions

How does the search_path influence identifier resolution and the "current schema"

Is it possible to define in which schema new tables get created by default? (Referred by "unqualified table names".) I've …

postgresql schema database-table search-path

Laying out a database schema for a calendar application

I want to write a calendar application. It is really recurring items that throw a wrench in the works for …

database schema calendar normalization

create synonym ora-01031 insufficient privileges

I need help understanding what grants/privileges a user needs to CREATE a SYNONYM when it points to another (different) …

oracle schema privileges grant synonym

XML Attributes vs Elements

When should you use XML attributes and when should you use XML elements? e.g. <customData> <records&…

xml schema modeling

What is the difference between Type and Element in WSDL?

In WSDL file a function can return a Type or an Element. I have used only custom types as a …

wsdl schema

Escaping Regex to get Valid JSON

In my schema, I want to recognize certain patterns to restrict the type of data that a user can enter. …

json schema

List table names, owner, schema and columns in SQL server database

In SQL SERVER how can I get a list of all table names, column names and owners? I have done …

sql-server schema owner

generate PHP classes from XSD?

Is there in the world analogues of JavaBeans or JAXB for PHP? Is it possible to generate PHP classes from …

php xml xsd schema code-generation

Mongoose: extending schemas

Currently I have two almost identical schemas: var userSchema = mongoose.Schema({ email: {type: String, unique: true, required: true, validate: emailValidator}, …

node.js schema mongoose

How to Schema Diff two databases using MySQL Workbench?

Does anyone know how to pull a database Scheme Diff for two databases using MySQL Workbench. v5.2 states it has …

mysql database schema mysql-workbench