SQL代码 

SELECT SCHEMA_NAME(SCHEMA_ID)AS ID,name as Table_name
FROM sys.tables;--查询表视图
查询表视图

 

USE master
RESTORE DATABASE RDA
   FROM DISK = 'D:\Preactor_Hub_full_20220124.bak'
   WITH MOVE 'Preactor_Hub' TO 'd:\Preactor_Hub.mdf',
   MOVE 'Preactor_Hub_log' TO 'd:\Preactor_Hub_log.ldf',
STATS = 10, REPLACE
备份

 

posted @ 2019-10-30 11:23  最爱吃汤圆27  阅读(118)  评论(0)  编辑  收藏  举报