In this example, Transact-SQL will create a new table with all columns from the rows in "old_table" in which the last name starts with "Ja." Advertisement. Article continues below this ad.

How to Reindex SQL Tables. ... substitute the name of your table for "table_name." For example, ... to execute your SQL code and list the results in a separate area beneath the code.