Alex Rivera | Logout

Questions tagged ddl

20 questions

Sort by: Newest Votes Active
69
votes
3
answers

Dropping column in Postgres on a large dataset

postgresql database-design ddl database-performance postgresql-9.2
asked 2013-03-29T08:44:38.027
14
votes
2
answers

How can I automatically convert MySQL DDL to Oracle DDL?

mysql sql oracle-database converters ddl
asked 2013-02-12T09:24:47.830
8
votes
1
answers

PostgreSQL indexes creation time

postgresql ddl
asked 2012-10-03T14:25:48.127
58
votes
7
answers

How to generate entire DDL of an Oracle schema (scriptable)?

oracle-database schema ddl
asked 2012-06-04T18:40:35.293
32
votes
2
answers

Mysql Add a new value to a column of data type enum

mysql ddl
asked 2012-04-06T17:50:51.833
11
votes
2
answers

Simplified/shorthand SQL Data Definition Languages?

mysql sql database-schema ddl shorthand
asked 2012-03-09T20:33:19.470
11
votes
5
answers

How to delete unused sequences?

postgresql ddl sequences
asked 2011-11-25T06:36:45.183
16
votes
2
answers

Do statistics referencing a column prevent that column from being dropped?

sql-server sql-server-2005 ddl
asked 2011-10-31T16:31:03.293
66
votes
7
answers

DROP FUNCTION without knowing the number/type of parameters?

sql postgresql plpgsql dynamic-sql ddl
asked 2011-10-01T20:54:07.897
9
votes
1
answers

Creating a trigger to only run when a new table is being created

sql database oracle-database triggers ddl
asked 2011-01-27T03:23:43.033
46
votes
2
answers

What does the number in parenthesis really mean?

mysql sql ddl
asked 2010-10-29T20:16:18.017
52
votes
5
answers

Test Column exists, Add Column, and Update Column

sql-server t-sql ddl
asked 2010-05-03T23:43:04.563
78
votes
11
answers

How do I get column datatype in Oracle with PL-SQL with low privileges?

oracle-database plsql ddl privileges
asked 2010-02-26T02:04:59.223
28
votes
8
answers

Is there a tool to generate a full database DDL for SQL Server? What about Postgres and MySQL?

sql mysql sql-server postgresql ddl
asked 2009-12-18T18:05:31.923
73
votes
3
answers

How do I DROP a constraint from a sqlite (3.6.21) table?

sqlite constraints ddl
asked 2009-12-10T23:16:39.943
342
votes
6
answers

PostgreSQL create table if not exists

sql postgresql ddl create-table database-table
asked 2009-11-19T19:48:41.917
16
votes
3
answers

SQL Server ALTER field NOT NULL takes forever

sql sql-server nullable blocking ddl
asked 2009-07-20T13:42:36.580
16
votes
5
answers

Limits on PostgreSQL schema changes inside transactions?

postgresql transactions schema ddl
asked 2009-07-10T10:09:06.343
154
votes
4
answers

Alter Table Add Column Syntax

sql sql-server t-sql ddl
asked 2009-04-27T16:57:24.943
776
votes
9
answers

SQLite primary key on multiple columns

sqlite primary-key ddl composite-primary-key
asked 2009-04-09T15:17:31.807