Some database scripts (continuous supplement)

1. query all table names in the specified database

Use yourdatabasename // your database name

Select * From information_schema.tables where table_type = 'base table'

2. Clear all table data

Exec sp_msforeachtable @ command1 = 'truncate table? ',
@ Whereand = 'and objectproperty (O. ID, ''tablehasforeignref '') = 0'
Exec sp_msforeachtable @ command1 = 'delete from? ',
@ Whereand = 'and objectproperty (O. ID, ''tablehasforeignref '') = 1'

3. recover database Restore database bworlddealergroup from disk = 'C: \ Program Files \ Microsoft SQL Server \ mssql.1 \ MSSQL \ backup \ bworlddealergroup 'with replace, move 'bworlddealertest' to 'C: \ Program Files \ Microsoft SQL Server \ mssql.1 \ MSSQL \ data \ bworlddealergroup. MDF ', move 'bworlddealertest _ log' to 'C: \ Program Files \ Microsoft SQL Server \ mssql.1 \ MSSQL \ data \ bworlddealergroup_log.ldf'