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
--
Showing posts with label thetables. Show all posts
Showing posts with label thetables. Show all posts
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?
Thanks
SELECT table_schema, table_name
FROM information_schema.tables
WHERE table_type = 'BASE TABLE'
David Portas
SQL Server MVP
tables in a particular SQL database?
Thanks
SELECT table_schema, table_name
FROM information_schema.tables
WHERE table_type = 'BASE TABLE'
David Portas
SQL Server MVP
Subscribe to:
Posts (Atom)