SQL (String property)

This property provides access to the DDL SQL statement that will be used when forward-engineering the object on which it is found. This property is both read-only and prefetch – do not attempt to store a value in it.

Tagged Values

Name	Value
Data_Type	String
Long_Id	{E7AB3CC0-47AD-4A10-8972-C0FB869EE7CB}+40202f68
tag_Display_Name_Resource	SQL
tag_Is_Physical	true
tag_Is_Prefetch	true
tag_Is_Read_Only	true
tag_Is_Read_Only_In_UI	true
tag_Release_Added	7.3.0
tag_Uses_ERwin_Macros	true

Valid values for object SQLServer_Database

Value Class Name Display Name
0 Web Web

1 Business Business

1 1GB 1GB

5 5GB 5GB

10 10GB 10GB

20 20GB 20GB

30 30GB 30GB

40 40GB 40GB

50 50GB 50GB

Valid values for object Permission

Value Class Name Display Name
0 All All

1 Alter Alter

2 Control Control

3 View_Definition View Definition

0 All All

1 Alter Alter

2 Control Control

3 Execute Execute

4 References References

5 Take_Ownership Take Ownership

6 View_Definition View Definition

0 All All

1 Alter Alter

2 Control Control

3 References References

4 Take_Ownership Take Ownership

5 View_Definition View Definition

0 All All

1 Alter Alter

2 Control Control

3 References References

4 Take_Ownership Take Ownership

5 View_Definition View Definition

Valid values for object Entity

Value Class Name Display Name
0 Disable Disable

1 Enable Enable

Valid values for object

Value Class Name Display Name
0 SQL SQL

1 Assembly Assembly

Valid values for object Domain

Value Class Name Display Name
0 SQL SQL

1 Assembly Assembly

Valid values for object Stored_Procedure

Value Class Name Display Name
0 SQL SQL

1 Assembly Assembly

Valid values for object Trigger

Value Class Name Display Name
0 SQL SQL

1 Assembly Assembly

Valid values for object Permission

Value Class Name Display Name
0 All All

1 Alter Alter

2 Alter_Any_Application_Role Alter Any Application Role

3 Alter_Any_Assembly Alter Any Assembly

4 Alter_Any_Asymmetric_Key Alter Any Asymmetric Key

5 Alter_Any_Certificate Alter Any Certificate

6 Alter_Any_Contract Alter Any Contract

7 Alter_Any_Database_DDL_Trigger Alter Any Database DDL Trigger

8 Alter_Any_Database_Event_Notification Alter Any Database Event Notification

9 Alter_Any_Dataspace Alter Any Dataspace

10 Alter_Any_Fulltext_Catalog Alter Any Fulltext Catalog

11 Alter_Any_Message_Type Alter Any Message Type

12 Alter_Any_Remote_Service_Binding Alter Any Remote Service Binding

13 Alter_Any_Role Alter Any Role

14 Alter_Any_Route Alter Any Route

15 Alter_Any_Schema Alter Any Schema

16 Alter_Any_Service Alter Any Service

17 Alter_Any_Symmetric_Key Alter Any Symmetric Key

18 Alter_Any_User Alter Any User

19 Authenticate Authenticate

20 Backup_Database Backup Database

21 Backup_Log Backup Log

22 Checkpoint Checkpoint

23 Connect Connect

24 Connect_Replication Connect Replication

25 Control Control

26 Create_Aggregate Create Aggregate

27 Create_Assembly Create Assembly

28 Create_Asymmetric_Key Create Asymmetric Key

29 Create_Certificate Create Certificate

30 Create_Contract Create Contract

31 Create_Database Create Database

32 Create_Database_DDL_Event_Notification Create Database DDL Event Notification

33 Alter_Any_Database_Audit Alter Any Database Audit

34 Create_Default Create Default

35 Create_Fulltext_Catalog Create Fulltext Catalog

36 Create_Function Create Function

37 Create_Message_Type Create Message Type

38 Create_Procedure Create Procedure

39 Create_Queue Create Queue

40 Create_Remote_Service_Binding Create Remote Service Binding

41 Create_Role Create Role

42 Create_Route Create Route

43 Create_Rule Create Rule

44 Create_Schema Create Schema

45 Create_Service Create Service

46 Create_Symmetric_Key Create Symmetric Key

47 Create_Synonym Create Synonym

48 Create_Table Create Table

49 Create_Type Create Type

50 Create_View Create View

51 Create_XMLSchema_Collection Create XML Schema Collection

52 Delete Delete

53 Execute Execute

54 Insert Insert

55 References References

56 Select Select

57 Showplan Showplan

58 Subscribe_Query_Notifications Subscribe Query Notifications

59 Take_Ownership Take Ownership

60 Update Update

61 View_Database_State View Database State

62 View_Definition View Definition

0 All All

1 Alter Alter

2 Control Control

3 Take_Ownership Take Ownership

4 View_Definition View Definition

Valid values for object Function

Value Class Name Display Name
0 Caller Execute As Caller

1 Self Execute As Self

2 Owner Execute As Owner

3 User_Id Execute As User

Valid values for object Stored_Procedure

Value Class Name Display Name
0 Caller Execute As Caller

1 Self Execute As Self

2 Owner Execute As Owner

3 User_Id Execute As User

Valid values for object Trigger

Value Class Name Display Name
0 Caller Execute As Caller

1 Self Execute As Self

2 Owner Execute As Owner

3 User_Id Execute As User

4 Login Execute As Login

Valid values for object Permission

Value Class Name Display Name
0 All All

1 Alter Alter

2 Control Control

3 References References

4 Take_Ownership Take Ownership

5 View_Definition View Definition

0 Alter Alter

1 Control Control

2 References References

3 TakeOwnership Take Ownership

4 ViewDefinition View Definition

0 All All

1 Alter Alter

2 Control Control

3 Execute Execute

4 References References

5 Select Select

6 TakeOwnership Take Ownership

7 ViewDefinition View Definition

8 Insert Insert

9 Delete Delete

10 Update Update

Valid values for object Function

Value Class Name Display Name
0 Scalar Scalar Function

1 InlineTable Inline Table Function

2 MultistatementTable Multistatement Table Function

3 ScalarReturnAssembly Scalar Return Assembly Function

4 TableReturnAssembly Table Return Assembly Function

Valid values for object Entity

Value Class Name Display Name
0 Disable Disable

1 Table Table

2 Auto Auto

Valid values for object Permission

Value Class Name Display Name
0 All All

1 Alter Alter

2 Control Control

3 Impersonate Impersonate

4 View_Definition View Definition

Valid values for object User_Id

Value Class Name Display Name
0 Login Login

1 Certificate Certificate

2 AsymmetricKey Asymmetric Key

3 NoLogin No Login

Valid values for object Function

Value Class Name Display Name
0 Called Called on null input

1 ReturnsNull Returns Null on null input

Valid values for object SQLServer_Partition_Function

Value Class Name Display Name
0 Range Range

Valid values for object Permission

Value Class Name Display Name
0 All All

1 AdministerBulkOperations Administer Bulk Operations

2 Alter Alter

3 AlterAnyApplicationRole Alter Any Application Role

4 AlterAnyConnection Alter Any Connection

5 AlterAnyCredential Alter Any Credential

6 AlterAnyDatabase Alter Any Database

7 AlterAnyEndpoint Alter Any Endpoint

8 AlterAnyEventNotification Alter Any Event Notification

9 AlterAnyLinkedServer Alter Any Linked Server

10 AlterAnyLogin Alter Any Login

11 AlterAssembly Alter Assembly

12 AlterAssemetricKey Alter Assemetric Key

13 AlterCertificate Alter Certificate

14 AlterContract Alter Contract

15 AlterDatabaseDDLTrigger Alter Database DDL Trigger

16 AlterDatabaseEventNotification Alter Database Event Notification

17 AlterDataspace Alter Dataspace

18 AlterFulltextCatalog Alter Fulltext Catalog

19 AlterMessageType Alter Message Type

20 AlterRemoteServiceBinding Alter Remote Service Binding

21 AlterResources Alter Resources

22 AlterRole Alter Role

23 AlterRoute Alter Route

24 AlterSchema Alter Schema

25 AlterServerState Alter Server State

26 AlterService Alter Service

27 AlterSettings Alter Settings

28 AlterSymmetricKey Alter Symmetric Key

29 AlterTrace Alter Trace

30 AlterUser Alter User

31 Authenticate Authenticate

32 AuthenticateServer Authenticate Server

33 BackupDatabase Backup Database

34 BackupLog Backup Log

35 Checkpoint Checkpoint

36 Connect Connect

37 ConnectReplication Connect Replication

38 ConnectSQL Connect SQL

39 Control Control

40 ControlServer Control Server

41 Create Create

42 CreateAggregate Create Aggregate

43 CreateApplicationRole Create Application Role

44 CreateAssembly Create Assembly

45 CreateAsymmetricKey Create Asymmetric Key

46 CreateCertificate Create Certificate

47 CreateContract Create Contract

48 CreateDatabase Create Database

49 CreateDatabaseEventNotification Create Database Event Notification

50 CreateDefault Create Default

51 CreateEndpoint Create Endpoint

52 CreateFulltextCatalog Create Fulltext Catalog

53 CreateFunction Create Function

54 CreateMessageType Create Message Type

55 CreateProcedure Create Procedure

56 CreateQueue Create Queue

57 CreateRemoteServiceBinding Create Remote Service Binding

58 CreateRole Create Role

59 CreateRoute Create Route

60 CreateRule Create Rule

61 CreateSchema Create Schema

62 CreateService Create Service

63 CreateSymmetricKey Create Symmetric Key

64 CreateSynonym Create Synonym

65 CreateTable Create Table

66 CreateTrace Create Trace

67 CreateType Create Type

68 CreateUser Create User

69 CreateView Create View

70 CreateXMLSchemaCollection Create XML Schema Collection

71 Delete Delete

72 Drop Drop

73 Execute Execute

74 ExternalAccessAssembly External Access Assembly

75 Impersonate Impersonate

76 Insert Insert

77 Receive Receive

78 References References

79 Select Select

80 Showplan Showplan

81 Shutdown Shutdown

82 SubscribeQueryNotification Subscribe Query Notification

83 TakeOwnership Take Ownership

84 UnsafeAssembly Unsafe Assembly

85 Update Update

86 ViewAnyDatabase View Any Database

87 ViewAnyDefinition View Any Definition

88 ViewDatabaseState View Database State

89 ViewDefinition View Definition

90 ViewServerState View Server State

91 CreateAnyDatabase Create Any Database

92 CreateDDLEventNotification Create DDL Event Notification

93 CreateTraceEventNotification Create Trace Event Notification

0 All All

1 Alter Alter

2 Control Control

3 Delete Delete

4 Execute Execute

5 Insert Insert

6 References References

7 Select Select

8 Take_Ownership Take Ownership

9 Update Update

10 View_Definition View Definition

11 ViewChangeTracking View Change Tracking

12 CreateSequence Create Sequence

0 Alter Alter

1 Control Control

0 All All

1 Administer_Bulk_Operations Administer Bulk Operations

2 Alter_Any_Connection Alter Any Connection

3 Alter_Any_Credential Alter Any Credential

4 Alter_Any_Database Alter Any Database

5 Alter_Any_Endpoint Alter Any Endpoint

6 Alter_Any_Event_Notification Alter Any Event Notification

7 Alter_Any_Linked_Server Alter Any Linked Server

8 Alter_Any_Login Alter Any Login

9 Alter_Resources Alter Resources

10 Alter_Server_State Alter Server State

11 Alter_Settings Alter Settings

12 Alter_Trace Alter Trace

13 Authenticate_Server Authenticate Server

14 Connect_SQL Connect SQL

15 Control_Server Control Server

16 Create_Any_Database Create Any Database

17 Create_DDLEvent_Notification Create DDL Event Notification

18 Create_Endpoint Create Endpoint

19 Create_Trace_Event_Notification Create Trace Event Notification

20 External_Access_Assembly External Access Assembly

21 Shutdown Shutdown

22 Unsafe_Assembly Unsafe Assembly

23 View_Any_Database View Any Database

24 View_Any_Definition View Any Definition

25 View_Server_State View Server State

26 AlterAnyServerAudit Alter Any Server Audit

27 Alter_Any_Availibility_Group Alter Any Availability Group

28 Alter_Any_Event_Session Alter Any Event Session

29 Alter_Any_Server_Role Alter Any Server Role

30 Create_Availibility_Group Create Availability Group

31 Create_Server_Role Create Server Role

0 All All

1 Alter Alter

2 Control Control

3 Execute Execute

4 References References

5 Select Select

6 TakeOwnership Take Ownership

7 ViewDefinition View Definition

0 All All

1 Alter Alter

2 Control Control

3 References References

4 Take_Ownership Take Ownership

5 View_Definition View Definition

0 All All

1 Control Control

2 Delete Delete

3 Execute Execute

4 Insert Insert

5 Select Select

6 TakeOwnership Take Ownership

7 Update Update

8 ViewDefinition View Definition

0 All All

1 Alter Alter

2 Control Control

3 Delete Delete

4 Insert Insert

5 References References

6 Select Select

7 Take_Ownership Take Ownership

8 Update Update

9 View_Definition View Definition

10 ViewChangeTracking View Change Tracking

Valid values for object Entity

Value Class Name Display Name
0 Off Off

1 On On

Valid values for object Trigger

Value Class Name Display Name
0 AllServer All Server

1 Database Database

Valid values for object Entity

Value Class Name Display Name
0 Permanent Permanent

1 SQLServerGlobalTemporary Global Temporary

2 SQLServerLocalTemporary Local Temporary

Valid values for object File

Value Class Name Display Name
0 SQLServerAssembly Assembly

1 SQLServerKey Key

2 SQLServerExecutable Executable

3 SQLServerKeyManagement Key Management

Valid values for object Permission

Value Class Name Display Name
0 All All

1 Control Control

2 References References

3 Take_Ownership Take Ownership

4 View_Definition View Definition

5 Execute Execute

Valid values for object

Value Class Name Display Name
0 Alter Alter

1 Control Control

2 Impersonate Impersonate

3 View_Definition View Definition

Valid values for object Permission

Value Class Name Display Name
0 All All

1 Alter Alter

2 Control Control

3 Impersonate Impersonate

4 ViewDefinition View Definition

0 All All

1 Alter Alter

2 Control Control

3 Delete Delete

4 Insert Insert

5 References References

6 Select Select

7 TakeOwnership Take Ownership

8 Update Update

9 ViewDefinition View Definition

Valid values for object Abstract_Domain

Value Class Name Display Name
0 Content Content

1 Document Document

Valid values for object Permission

Value Class Name Display Name
0 All All

1 Alter Alter

2 Control Control

3 Execute Execute

4 References References

5 Take_Ownership Take Ownership

6 View_Definition View Definition

Valid values for object

Value Class Name Display Name
0 ModifiesSQLData Modifies SQL Data

1 ReadsSQLData Reads SQL Data

2 ContainsSQLData Contains SQL Data

3 NoSQL No SQL

Value	Class Name	Display Name
0	Web	Web
1	Business	Business
1	1GB	1GB
5	5GB	5GB
10	10GB	10GB
20	20GB	20GB
30	30GB	30GB
40	40GB	40GB
50	50GB	50GB

SQL (String property)

Tagged Values

Valid values for object SQLServer_Database ValueClass NameDisplay Name 0WebWeb 1BusinessBusiness 11GB1GB 55GB5GB 1010GB10GB 2020GB20GB 3030GB30GB 4040GB40GB 5050GB50GB

Valid values for object Entity ValueClass NameDisplay Name 0DisableDisable 1EnableEnable

Valid values for object ValueClass NameDisplay Name 0SQLSQL 1AssemblyAssembly

Valid values for object Domain ValueClass NameDisplay Name 0SQLSQL 1AssemblyAssembly

Valid values for object Stored_Procedure ValueClass NameDisplay Name 0SQLSQL 1AssemblyAssembly

Valid values for object Trigger ValueClass NameDisplay Name 0SQLSQL 1AssemblyAssembly

Valid values for object Function ValueClass NameDisplay Name 0CallerExecute As Caller 1SelfExecute As Self 2OwnerExecute As Owner 3User_IdExecute As User

Valid values for object Stored_Procedure ValueClass NameDisplay Name 0CallerExecute As Caller 1SelfExecute As Self 2OwnerExecute As Owner 3User_IdExecute As User

Valid values for object Trigger ValueClass NameDisplay Name 0CallerExecute As Caller 1SelfExecute As Self 2OwnerExecute As Owner 3User_IdExecute As User 4LoginExecute As Login

Valid values for object Function ValueClass NameDisplay Name 0ScalarScalar Function 1InlineTableInline Table Function 2MultistatementTableMultistatement Table Function 3ScalarReturnAssemblyScalar Return Assembly Function 4TableReturnAssemblyTable Return Assembly Function

Valid values for object Entity ValueClass NameDisplay Name 0DisableDisable 1TableTable 2AutoAuto

Valid values for object Permission ValueClass NameDisplay Name 0AllAll 1AlterAlter 2ControlControl 3ImpersonateImpersonate 4View_DefinitionView Definition

Valid values for object User_Id ValueClass NameDisplay Name 0LoginLogin 1CertificateCertificate 2AsymmetricKeyAsymmetric Key 3NoLoginNo Login

Valid values for object Function ValueClass NameDisplay Name 0CalledCalled on null input 1ReturnsNullReturns Null on null input

Valid values for object SQLServer_Partition_Function ValueClass NameDisplay Name 0RangeRange

Valid values for object Entity ValueClass NameDisplay Name 0OffOff 1OnOn

Valid values for object Trigger ValueClass NameDisplay Name 0AllServerAll Server 1DatabaseDatabase

Valid values for object Entity ValueClass NameDisplay Name 0PermanentPermanent 1SQLServerGlobalTemporaryGlobal Temporary 2SQLServerLocalTemporaryLocal Temporary

Valid values for object File ValueClass NameDisplay Name 0SQLServerAssemblyAssembly 1SQLServerKeyKey 2SQLServerExecutableExecutable 3SQLServerKeyManagementKey Management

Valid values for object Permission ValueClass NameDisplay Name 0AllAll 1ControlControl 2ReferencesReferences 3Take_OwnershipTake Ownership 4View_DefinitionView Definition 5ExecuteExecute

Valid values for object ValueClass NameDisplay Name 0AlterAlter 1ControlControl 2ImpersonateImpersonate 3View_DefinitionView Definition

Valid values for object Abstract_Domain ValueClass NameDisplay Name 0ContentContent 1DocumentDocument

Valid values for object Permission ValueClass NameDisplay Name 0AllAll 1AlterAlter 2ControlControl 3ExecuteExecute 4ReferencesReferences 5Take_OwnershipTake Ownership 6View_DefinitionView Definition

Valid values for object ValueClass NameDisplay Name 0ModifiesSQLDataModifies SQL Data 1ReadsSQLDataReads SQL Data 2ContainsSQLDataContains SQL Data 3NoSQLNo SQL