How to list all tables with their schemas in a database? ; SELECT ; SCHEMA_NAME(schema_id) As SchemaName , ; name As TableName ; from sys.tables.
確定! 回上一頁