匯出資料庫所有table

匯出資料庫所有table

SELECT TABLE_SCHEMA + '.' + TABLE_NAME as '結果' 
FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_TYPE = 'BASE TABLE'
AND TABLE_SCHEMA = 'dbo';s