To create a select statement for all tables in the database

February 19, 2009 Uncategorized Comments Off on To create a select statement for all tables in the database

The following will create a select statement for Sql Server for all tables in the database:

SELECT ‘SELECT FROM ‘ + name FROM sys.Tables

Comments are closed.