In this section we shall run a SQL query. Table data gets displayed in Data tab, as shown in Figure 17. Click on Refresh to display the table data added as shown in Figure 16. The Data tab in the Explorer still does not display the data. INSERT INTO wlslog ( logid,category,type,servername,code,msg ) VALUES( 7,’Notice’,’WebLogicServer’,’AdminServer’,’BEA-000360′,’Server started in RUNNING mode’ ) Ĭlick on Execute SQL to run the SQL script as shown in Figure 14.īecause AutoCommit is ON by default, the SQL transaction gets committed and data gets added and as the Messages tab in Figure 15 shows, 7 rows affected. INSERT INTO wlslog ( logid,category,type,servername,code,msg ) VALUES( 6,’Notice’,’WebLogicServer’,’AdminServer’,’BEA-000365′,’Server state changed to RUNNING’ )
INSERT INTO wlslog ( logid,category,type,servername,code,msg ) VALUES( 5,’Notice’,’WebLogicServer’,’AdminServer’,’BEA-000361′,’Started WebLogic AdminServer ‘ ) INSERT INTO wlslog ( logid,category,type,servername,code,msg ) VALUES( 4,’Notice’,’WebLogicServer’,’AdminServer’,’BEA-000365′,’Server state changed to RESUMING’ ) INSERT INTO wlslog ( logid,category,type,servername,code,msg ) VALUES( 3,’Notice’,’WebLogicServer’,’AdminServer’,’BEA-000365′,’Server state changed to ADMIN’ ) INSERT INTO wlslog ( logid,category,type,servername,code,msg ) VALUES( 2,’Notice’,’WebLogicServer’,’AdminServer’,’BEA-000365′,’Server state changed to STARTING’ ) I NSERT INTO wlslog ( logid,category,type,servername,code,msg ) VALUES( 1,’Notice’,’WebLogicServer’,’AdminServer’,’BEA-000365′,’Server state changed to STANDBY’ ) Click on Edit in the toolbar as shown in Figure 13 to launch a SQL Editor.Ĭopy and paste the following SQL script in the SQL Editor. In this section we shall add table data to the wlslog table using a SQL Editor. Initially the table is empty, as shown by no data being displayed in Figure 12. Select the Data tab to display the table data. Select the Columns tab to display the table’s columns as shown in Figure 11.
Select the dbo.wlslog table in Object Explorer as shown in Figure 10, and tabs for the table’s Columns, Data, Statistics, Indexes, Constraints and other table-related objects get displayed. Tabs are provided for a database’s Tables, Views and Indexes. The database objects for the tempdb database are displayed in separate categories. The Explorer includes its own Object Explorer. The Explorer is different from the Object Explorer View which is displayed by default. Click on Explorer in the toolbar as shown in Figure 9. Toad for SQL Server provides the Explorer to explore database objects. The table wlslog gets added to the Object Explorer, as shown in Figure 7.Ī new table provides several options, which are displayed with a right-click on a table in Object Explorer as shown in Figure 8. The confirmation dialog indicates Table successfully created. Īfter adding all columns click on OK to create the table, as shown in Figure 6. The default data type for each new column is int.
The data type in the Type column is selected from the drop-down, as shown in Figure 5.
Select the Not Null checkbox for the logid column and click on Set Primary Key to set the column as a primary key column as shown in Figure 3.Ĭlick on Add as shown in Figure 4 to add each of the other columns category, type, servername, code and msg. Specify table name as wlslog and specify primary key column as logid of type int. Default settings are provided for Database and Schema. The Database, Schema and table name must be selected or specified. The Create Table wizard gets started, as shown in Figure 2. To create a new database table in tempdb database select the Tables tab and click on Create a table as shown in Figure 1. In this section we shall create table wlslog with columns logid, category, type, servername, code and msg. This article has the following sections.Ĭreating a Database Table with the New Table WizardĬreating a Database Table with New Table Wizard We shall also discuss some of the other features including setting the current connection, dropping a table, and dropping a connection.
Toad for SQL Server is a SQL Server client with all the features required to access the database, and create and manage database objects on the same Windows Server, in this article we shall create a database table, add table data, and query the table. Username: To connect to the operating system, The Generate SQL | statement/script sub-menu now has a new option, Append To Editor. Run faster, more reliable databases by doing more work in less time with Toad™… Features.