Tag: ddl

Found 76 results for 'ddl'.

1) postgresql - Best way to populate a new column in a large table?
2) postgresql - Basic transactional DDL script in PostgreSQL
3) postgresql - Speed up creation of Postgres partial index
4) sql-server - SQL Server Concurrent Insert/Update and Storing Data
5) sql-server - Rollback group of DDL statements
6) ddl - Why won't some DBMS's allow rollback for certain DDL statements?
7) sql-server - Implications of removing unnecessary column from primary key
8) sql-server - What events still occur within a transaction that gets rolled back?
9) sql-server - Apparantly errorneous Exceeds 8K row length message
10) mysql - Can one make MySQL cluster on a unique index rather than a primary key?
11) postgresql - Reclaim disk space from dropped column without downtime
12) postgresql - Does issuing DDL against a view in PostgreSQL take out the same locks as issuing DDL against a table?
13) sql-server - SQL Server Concurrent Inserts and Deletes
14) postgresql - PgTap, unit test a foreign key is deferrable
15) mysql - Does InnoDB DROP INDEX release disk space without OPTIMIZE TABLE?
16) mysql - Online Schema migration in MySQL : When to start?
17) sql-server - Create stored procedure inside try-catch block
18) mysql - Does PostgreSQL support online schema modification (DDL)?
19) oracle - Why is truncate DDL?
20) sql-server - What happens when you create the primary key of a table on a different filegroup?
21) oracle - How to generate create table script without primary and foreign key in Oracle
22) algorithm - How do you like your primary keys?
23) mysql - Is string or int preferred for foreign keys?
24) sql-server - Check constraint references another column in same table
25) oracle - SQL Error: OA-12991 - Unable to Drop a Column after removing all referenced Multi-Column constraints
26) postgresql - Idempotent PostgreSQL schema dump that can be applied to an existing DB
27) sql-server - Reset IDENTITY value
28) oracle - Oracle, Is there a way to request a lock with alter table drop partition?
29) postgresql - Understanding the output of \d <table> in psql
30) sql-server - How to create a partitioned table based on date?
31) oracle - Modifying a part (one procedure) in oracle database package
32) postgresql - Retrieve Names of Check Constraints Specific to a Column
33) oracle - Script out Oracle DDL in an automated fashion
34) mysql - Multiple foreign keys referencing a single table in one statement
35) postgresql - How to parametrize DDL in a plpgsql procedure?
36) sql-server - How to access external DLL's static methods that incorporate output parameters in SQL Server
37) sql-server - How do I drop all constraints from all tables?
38) oracle - Why am I getting PLS-00103 when I try to create a table in a PL/SQL procedure?
39) postgresql - Convert postgres varchar[] to text[] without downtime
40) oracle - Get the DDL for all indexes - Oracle
41) sql-server - How to store a version sequence per product
42) sql-server - If Exists before Update or Delete?
43) db2 - Change column from NOT LOGGED to LOGGED
44) sql-server - How to capture sp_refreshsqlmodule event
45) mysql - Truncate temporary table commits transaction?
46) postgresql - How to drop all indexes not used for primary keys or constraints
47) sql-server - Changing the datatype of the primary key columns of partitioned tables
48) sql-server - How would I reset all of the identity values for a table, and reseed the auto-number in Sql Server 2008
49) database-design - What is the advantage of using numeric primary keys in a relational database?
50) postgresql - PostgreSQL increase column length