Well, if you happen to be using Sql Server you can do that sort of thing in T-Sql. In Oracle, you can also accomplish the same thing using pl/sql. Either way i'd do it in a stored ...

Occasionally you might want to submit SQL statements that are not queries, such as statements that drop tables or create indexes. These non-query, non-SELECT statements do not produce output. You can ...

The CONNECT statement establishes a connection with the DBMS. You establish a connection to send DBMS-specific SQL statements to the DBMS or to retrieve DBMS data. The connection remains in effect ...