Top "Ddl" questions

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

Using ALTER to drop a column if it exists in MySQL

How can ALTER be used to drop a column in a MySQL table if that column exists? I know I …

mysql ddl mysql4
How can I avoid getting this MySQL error Incorrect column specifier for column COLUMN NAME?

How can I avoid getting this MySQL error Incorrect column specifier for column topic_id ? MySQL Error... #1063 - Incorrect column …

mysql sql auto-increment ddl
Create a temporary table in MySQL with an index from a select

I have a stored function where I use temporary tables. For performance reasons, I need an index in that table. …

mysql ddl temp-tables
ALTER TABLE without locking the table?

When doing an ALTER TABLE statement in MySQL, the whole table is read-locked (allowing concurrent reads, but prohibiting concurrent writes) …

sql mysql ddl alter-table
difference between cascade and restrict? SQL DDL database

Could anyone tell me what exactly cascade, and restrict mean? It's in database systems subject the DDL Part and what …

sql database ddl
Get VIEW ddl using query

For database re-architecture I need to get DDL of each table and view in the database(Oracle). I don't want …

sql oracle ddl dbms-metadata
Is it possible to roll back CREATE TABLE and ALTER TABLE statements in major SQL databases?

I am working on a program that issues DDL. I would like to know whether CREATE TABLE and similar DDL …

sql transactions ddl create-table
How do you add a computed column to a Table?

How can I add a computed column to a table that already exists? S.O. has Computed Column Help - …

tsql ddl
How to generate DDL for all tables in a database in MySQL

How to generate the DDL for all tables in a database of MySQL at once. I know that the following …

mysql database database-design ddl
How can I generate (or get) a ddl script on an existing table in oracle? I have to re-create them in Hive

How can I generate a DDL script on an existing table in oracle? I am working on a project where …

sql oracle ddl database-metadata