List All Tables in a Database in SQLSERVER2008

CGN007
Posted by CGN007 under Sql Server category on | Points: 40 | Views : 890
SELECT TABLE_SCHEMA + '.' + TABLE_NAME [Table Name], *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
ORDER BY 1

Comments or Responses

Login to post response