To complete the operation, click the Execute button (also available from the right-click context menu) in the top left corner of the query editor. We just deleted all tables in the sakila database and database itself permanently. In the newly opened query editor, I’ll just paste the SQL script for creating the sample database and hit the Execute button to recreate the database: Let’s see how we can do that.īack in ApexSQL server explorer, right-click our instance and choose New query: But don’t worry – this is just a sample database, and we can recreate it anytime. Note: The Sakila sample database is available from this page. If the connection is remote, give it a few seconds. There’s always a slight delay when dealing with remote locations. You can always verify your connection and status of a query in the lower status bar: I’ll run another long script to populate the tables with sample data: It also depends on the complexity of the script that you’re running, the number of batches, etc. Query results are displayed right below the SQL editor:Īside from executing queries, the VS Code extension also enables users to generate DDL and DML scripts using the integrated SQL editor.
0 Comments
Leave a Reply. |