demo - ml_server.ml_delete

Description

none

Procedure properties

name	value
name	ml_server.ml_delete_device
created
type	SQL stored procedure

Parameters

name	datatype	length	in/out	comment
@device	varchar	255	in

Usage

EXEC ml_server.ml_delete_device
    @device = @myvarchar1

Dependency graph

ml_deviceml_device_addressml_listeningml_delete_device

Objects that ml_server.ml_delete_device depends on

name	object type	level
ml_device	table	1
ml_device_address	table	1
ml_listening	table	1

Code

create procedure ml_server.ml_delete_device( in @device varchar(255) ) 
begin
  delete from ml_device_address where device_name = @device;
  delete from ml_listening where device_name = @device;
  delete from ml_device where device_name = @device
end

demo - procedures - ml_server.ml_delete_device

Description

Procedure properties

Parameters

Usage

Dependency graph

Objects that ml_server.ml_delete_device depends on

Code