Delete generated brackets (Type and Folder name ) & delete generated decimal points (#1570)
I need to remove the square brackets content from the movie.
1.Properties-->Attributes-->"Type"
2.Project-->"Folder name"
Generated MS-SQL is not compiled by standard
Provide the video as follows:
http://bit.ly/2NA6Ppv
https://drive.google.com/open?id=1PhkKcjU6TxFyKtEGR0hA0T8YJumSsag-
Created
20 November 2018 18:26:30
Closed
6 December 2018 15:10:04
Requested by
FU CHI CHUANG
State
Solved
Version
11.9
OperatingSystem
windows 10
Solved in
Unsolved
Dusan Rodina - softwareideas.net 26 November 2018 14:00:51
Hello,
The output is correct, it is generated this way (with brackets) also by Microsoft SQL Server Management Studio. It should be no problem to execute it by MS SQL Server. The problem may be that the schema (defined by the prefix) is not defined. You can go to Diagram Properties dialog (right click on diagram canvas/Diagram Properties) and type e.g. 'dbo' to Custom namespace text box. Then the table name will be generated as [dbo]..
However, if you really want to omit the mentioned parts, it is possible to customize the built-in template.
Open Process tab in the ribbon, click on Source Code Templates button (Templates group). A new tab Source Code Template Management will be open.
Choose SQL DDL in Language drop down list (in the left top part of the window).
Select SQL DDL template item in Templates list. Switch to Files tab in the right top tab control.
Select Table.sql item and click on Edit File button. The editor tab with the template for table will show.
Do the following changes and then save them using Save button:
Change this part:
CREATE TABLE [<%==SIM:Coalesce(Element.Schema,"dbo")==%>].[<%==SIM:Element.Name==%>]
to
CREATE [<%==SIM:Element.Name==%>]
and this part:
[<%==SIM:Attribute.Name==%>] [<%==SIM:Attribute.TypeName==%>]
to
[<%==SIM:Attribute.Name==%>]<%==SIM:Attribute.TypeName==%>