select * from INFORMATION_SCHEMA.TABLES
USE Your_Database GO SELECT * FROM sys.Tables GO
SELECT * FROM sys.tables
SELECT * FROM sys.objects WHERE type='u'
SELECT * FROM sys.Tables
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)