Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA | swissarmyknife(*) |
| Priority | Major |
| Complexity | Unknown |
| Component | Q Analyzer |
| Version | 15.0 |
For SQL Server
When generating a new table via
select * into
Allow removing/disabling identity on a column during the creation of the new table. Currently if a table is generated this way, and an ALTER is attempted, the Identity cannot be removed. The Identity setting for a column can be removed by SQL Server Management Studio, but it can't be removed in ADStudio during ALTER.
There is no way to do this through TSQL. Management studio does this by creating a temp table, moving the data into that temp table. Then drops the column and readds the column without the identity property then moves the data back into the table. I need to discuss this further before we do work...
I have just read through ms sql servers documentation on this and they specifically state that this can not be done through tsql. Management studio also warns you that these types of changes can only be done through a table drop and recreate. We do not perform drop statements on alter process as this can cause severe damage to objects and data. Will not support until sql server offers a cleaner way of doing this.
I have just read through ms sql servers documentation on this and they specifically state that this can not be done through tsql. Management studio also warns you that these types of changes can only be done through a table drop and recreate. We do not perform drop statements on alter process as this can cause severe damage to objects and data. Will not support until sql server offers a cleaner way of doing this.
Issue #10379 |
| Closed |
| Won't Fix |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
There is no way to do this through TSQL. Management studio does this by creating a temp table, moving the data into that temp table. Then drops the column and readds the column without the identity property then moves the data back into the table. I need to discuss this further before we do work...