Name

DROP-VIEW-FROM-CLASS — Delete table from SQL database.

Function

Syntax

      (drop-view-from-class view-class-name &key (database *default-database*)) => 

Arguments and Values

view-class-name

The name of the view class.

Description

Removes a table defined by the View Class VIEW-CLASS-NAME from DATABASE which defaults to *DEFAULT-DATABASE*.

Examples

	* (list-tables)
	("FOO" "BAR")	
	* (drop-view-from-class 'foo)
	* (list-tables)
	("BAR")	
      

Side Effects

Deletes a table from the SQL database.

Affected by

Whether the specified table exists in the SQL database.

Exceptional Situations

A condition may be signalled if the table does not exist in the SQL database or if the SQL connection does not have sufficient permissions to delete tables.

See Also

create-view-from-class
def-view-class

Notes