List all tabels in database

1. SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE table_type = 'BASE TABLE'

2. SELECT name FROM dbo.sysobjects WHERE xtype = 'U'

No comments: