Top "Ddl" questions

Data Definition Language is a subset of SQL to manipulate structural elements of a database, not the content of tables.

Generate DDL script at MAVEN build with Hibernate4 / JPA 2.1

It seems like the hibernate3-maven-plugin used to generate DDL create/drop scripts is not compatible any more with Hibernate 4.3 …

maven ddl hibernate-4.x jpa-2.1 hibernate3-maven-plugin
What is the use of reorg command in IBM DB2?

What is the use of reorg command in ibm db2 db ? What does Reorg do internally ? Is it necessary to …

sql db2 ddl reorganize
Is there a postgres command to list/drop all materialized views?

I am creating multiple views in my code and each time the code is run, I would like to drop …

database postgresql ddl materialized-views
Do statistics referencing a column prevent that column from being dropped?

I'm trying a very simple drop column statement: alter table MyTable drop column MyColumn and receiving several errors along the …

sql-server sql-server-2005 ddl
Generate schema from entities using JPA2 + Hibernate + Eclipse 4.2 + MySQL 5.5

I am new to Hibernate/JPA and I am stuck at what I think is the last step. I have …

mysql hibernate jpa-2.0 ddl
Change column type from timestamp WITHOUT time zone to timestamp WITH time zone

I found this ALTER COLUMN statement in the PostgreSQL 9.3 ALTER TABLE manual page: ALTER TABLE audits ALTER COLUMN created_at …

sql postgresql timezone ddl alter-table
Understanding QUOTED_IDENTIFIER

We just ran into a problem with one of our stored procs throwing an error; SELECT failed because the following …

sql-server settings ddl
How to see the metadata of objects in Vertica Database (desc like Oracle)

I would like to know how I can get the metadata of an object in a Vertica database; like metadata …

ddl vertica
How to drop a unique constraint on a column in Postgres?

This is my database table CREATE TABLE cart ( id UUID NOT NULL PRIMARY KEY, shop_user_id UUID UNIQUE ); And …

postgresql constraints ddl
How to extract Stored Procedure body in Teradata

I'm trying to extract Stored procedure DDL by querying system tables. If I run the following query select * from dbc.…

procedure ddl teradata system-tables