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
Extraction and scripting of user defined datatypes needs to insure we are retrieving any defaults and rules bound to the datatype. The script will now also need to script the binding of the rule and default. The gui should correctly show the default and rule of the datatype if bound. These steps are required for schema synchronization to work.
The scripting of the sp_bind* command should qualify the target rule & default.
|
|
406 KB
|
|
192 KB
SQL Server 2008 and above will now use the DROP TYPE DDL syntax.
The User Defined Data Type GUI has been modified to handle new code. The scripting of the bind for defaults/rules has been moved to its scripting class from the gui class for sql server. The bind scripts are now part of the script create for sql server data types. So a data type that has a rule or default associated to it will script its binding on create. extraction has been fixed so that the default/rule owner is properly extracted for sql server 2008 and above.
Committed revision: 49980
The User Defined Data Type GUI has been modified to handle new code. The scripting of the bind for defaults/rules has been moved to its scripting class from the gui class for sql server. The bind scripts are now part of the script create for sql server data types. So a data type that has a rule or default associated to it will script its binding on create. extraction has been fixed so that the default/rule owner is properly extracted for sql server 2008 and above.
Committed revision: 49980
Verified in ADS 18 Devi 161.
Now Datatype properties window UI shows Default and Rule correctly.
If we do Script Object to Window As- > CREATE
CREATE script include Default and Rule name properly.
If we do Script Object to Window As- > DROP
Drop Type script generated successfully.(see attached screenshot)
Verified in ADS 18 Devi 161.
Now Datatype properties window UI shows Default and Rule correctly.
If we do Script Object to Window As- > CREATE
CREATE script include Default and Rule name properly.
If we do Script Object to Window As- > DROP
Drop Type script generated successfully.(see attached screenshot)
Datatype properties window UI shows Default and Rule correctly.
If we do Script Object to Window As- > DROP
Drop Type script generated successfully.
Verified closed in ADS 18.0.0-rc-16
Datatype properties window UI shows Default and Rule correctly.
If we do Script Object to Window As- > DROP
Drop Type script generated successfully.
Verified closed in ADS 18.0.0-rc-16
Issue #14447 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build v18.0.0-devi-151 |
| No time estimate |
SQL Server 2008 and above will now use the DROP TYPE DDL syntax.