ddl
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 whet开发者_开发技巧her CREATE TABLE and similar DDL can be rolled back in[详细]
2023-02-04 01:23 分类:问答How can I customize the DDL generated with Hibernate's hbm2ddl (using annotations)?
Here\'s what I want to do: I\'m using Hibernate (3.3.2) to map my Ingres 10 database. My java entities are generated after a meta model, so we decided to use annotations to ease things.[详细]
2023-02-03 07:27 分类:问答What causes this error..please run "exec sp_register_custom_scripting 'CUSTOM_SCRIPT', your_script?
Configuration SQL 2005 (Server A) replicates to SQL 2008(Server B) which replicates to SQL 2008(Server C).[详细]
2023-02-02 08:17 分类:问答Drop column and all dependent objects using data definition language
I need to remove a column from a table, but when I try to remove it: The object \'object_name\' is dependent[详细]
2023-01-31 11:51 分类:问答is there a tool to dump a database schema (SQL DDL) to XML?
I\'m looking to automatica开发者_Go百科lly generate an XML version of a database schema from SQL (Postgres) DDL.[详细]
2023-01-30 18:08 分类:问答In MySQL, with FKs what's "CONSTRAINT" do?
I\'ve looked at the MySQL 5.1 docs, and still can\'t figured this out -- that being I noticed a difference betwee开发者_运维知识库n the code I input into MySQL and output code by the system.[详细]
2023-01-29 06:28 分类:问答Is it possible to trace back the "create index" statement used on a table
I want to create indices on a table. I didn\'t realize it will grow so fast in size that I\'m not even able to select a handful of rows. Now, I want this table to be so alike another table. So I want[详细]
2023-01-23 10:35 分类:问答What does the number in parenthesis really mean?
I always thought that the number i开发者_Python百科n the parenthesis represented the field length?[详细]
2023-01-23 05:24 分类:问答SQL CLR DDL trigger written on C#
Is it possible to create a database/DDL trigger in C#?And, if so, then how? [EDIT] Basically, I decided to use CLR for the database trigger becau开发者_开发技巧se I want to utilize C# SMO to script[详细]
2023-01-21 08:01 分类:问答Entity Designer Database Generation Power Pack generates datetime and not datetime2 for ProviderManifestToken = 2008
Im having trouble with the DDL-generation from EDMX using the \"Entity De开发者_开发知识库signer Database Generation Power Pack\" add-on. It generates datetime-columns instead on datetime2 even though[详细]
2023-01-20 08:25 分类:问答