HasDDLCommands Property

In This Topic

True if command has DDL commands

Syntax

Visual Basic
C#

'Declaration
 
Public ReadOnly Property HasDDLCommands As System.Boolean

'Usage
 
Dim instance As VistaDBCommand
Dim value As System.Boolean
 
value = instance.HasDDLCommands

public System.bool HasDDLCommands {get;}

Example

The following example will write information about whether the database structure will be changed by executing this query. Output:

Query has DDL commands

public void CheckDDL(VistaDBConnection connection)
{
	VistaDBCommand command = new VistaDBCommand(string.Empty, connection);
            
	//Check first query
	command.CommandText = "CREATE TABLE Orders (ID_Order Integer NOT NULL IDENTITY(1, 1) PRIMARY KEY, ID_Customer Integer)";
	if(command.HasDDLCommands)
		Console.WriteLine("Query has DDL commands");
	else
		Console.WriteLine("Query does not have DDL commands");
}

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

VistaDBCommand Class
VistaDBCommand Members

Send Feedback