This section lists some of the statements that you can pass to the DBMS by using the SQL Procedure Pass-Through Facility's EXECUTE statement. CREATE creates a DBMS table, view, index, or other DBMS ...

Beginning in Version 7, you can associate a libref directly with your DBMS data and use the libref in your Pass-Through query just as you would use any SAS data set. As a result, you can now create a ...

Create a view, named NumberCust which is showing how many customers there are on each territory (use table [Sales].[Customer]). Construct a trigger, named trgDelete, that is affected DELETE ...