Top "Schema" questions

Schema means shape, or more generally, plan.

XML XSD Schema - Enforce Unique Attribute Values in Schema

Lets say I have a schema that defines the following XML: <Values> <Add Key="Key1">Value 1&…

xml schema xml-validation
Database schema for organizing historical stock data

I'm creating a database schema for storing historical stock data. I currently have a schema as show below. My requirements …

sql sqlite schema stocks
Query to show all tables and their collation

Is there a query that can be run in mysql that shows all tables and their default collation? Even better …

mysql schema collation
YAML Schema Validation?

Is there a schema validation language for YAML? I've googled but couldn't find anything useful. Something like XSD format, using …

validation xsd schema yaml
JSON Schema - specify field is required based on value of another field

Wondering if this is possible with schema draft 03. I've gotten dependencies working elsewhere, I think there is possibly just some …

json dependencies schema jsonschema
How can I set the current schema for DB2 using Hibernate/JDBC?

I used to use currentSchema=MYSCHEMA; in my JDBC URL connection, but the version of DB2 we're using no longer …

jdbc schema db2
How to delete SOLR indexed data by query with curl?

I have a SOLR schema.xml like this: <field name="cartype" type="lowercase" indexed="true" stored="true"/> <…

curl solr schema http-delete
Execute .sql schema in psycopg2 in Python

I have a PostgreSQL schema stored in .sql file. It looks something like: CREATE TABLE IF NOT EXISTS users ( id …

python postgresql schema psycopg2
How to get the schema definition from a dataframe in PySpark?

In PySpark it you can define a schema and read data sources with this pre-defined schema, e. g.: Schema = StructType([ …

apache-spark dataframe pyspark schema azure-databricks
How to generate a diagram of a very large database schema (SQL Server)

I have a very large database I need to diagram. The database is SQL Server 2008 on x64. It is large …

sql-server database-design schema database-diagramming