× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
nhilam reported 2013-01-22T18:33:50Z  · NielsGron last modified 2014-06-25T00:45:32Z

Schema script generator includes Identity columns in INSERT statements


review feature
Dev
John LH
JohnLH
QA
Priority Low
Complexity Unknown
Component Tools - Schema Script Gen
Version Future - 0.1
  1. Select an DB that contains a table with an IDENTITY type column, and has at least one row of data.
  2. Right click on the DB and select Tools/Schema Script Generator
  3. Check the "Tables" checkbox on the LHS panel
  4. On the RHS, select a table that contains an IDENTITY type column, and has at least one row of data
  5. Click Next
  6. Check the "Include INSERT statements for data of Tables" checkbox
  7. Click Next
  8. Click Close

Note that the generated script file contains insert statements that include the IDENTITY column. The user will have to manually remove this column name and value from the INSERT statement in order for the statement to execute correctly.

Issue #8230

Closed
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017