Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: Edit SQL > Flow Control for Scripts > Example Script: Populate Tables and Data

Example Script: Populate Tables and Data

The following script adds a set of prompts so you can quickly specify the number of tables to create and if you want to include data, prompts you for the number of rows to insert. Toad then creates the tables and populates the data.

--: PROMPT tableCount = 'Enter the number of test tables to create'

--: SET i = 0

--: WHILE i < tableCount

--: SET i = i + 1

CREATE TABLE testTable{{Unquote(:i)}} ( id INT PRIMARY KEY );

--: ENDWHILE

--: NOTIFY 'Done creating tables.'

--: ASK addData = 'Fill tables with test data?'

--: IF addData

--: PROMPT rowCount = 'Enter number of rows to create'

--: SET i = 0

--: WHILE i < tableCount

--: SET i = i + 1

--: SET j = 1

--: WHILE j <= rowCount

INSERT INTOtestTable{{Unquote(:i)}} VALUES (:j);

--: SET j = j + 1

--: ENDWHILE

--: PRINT 'Completed filling table ' || i

--: ENDWHILE

--:ENDIF