SQL代码
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
SELECT SCHEMA_NAME(SCHEMA_ID)AS ID,name as Table_name FROM sys.tables;--查询表视图
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
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