Grid display
Sunday, February 19, 2012
Generate a List of Tables
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
--
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment