Deleting Or Selecting all all table data using a single command.

Using this System SP we can delete or select all table data from a SQL SERVER database.

EXECUTE sp_MSforeachtable ‘select * from ?’

EXECUTE sp_MSforeachtable ‘DELETE FROM ?’