Is there an easy way to generate a list (plain text will do) of all the
tables in a particular SQL database?
ThanksSELECT table_schema, table_name
FROM information_schema.tables
WHERE table_type = 'BASE TABLE'
--
David Portas
SQL Server MVP
--
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment