How to select all the rows from all the tables in the sql server database

select all the rows from all the tables in the sql server database

Solution

EXEC sp_MSforeachtable @command1 = “SELECT * FROM ?”

About the Author

avatar