How list out all tables in MSSQL?

Alternate way, also fetches schema name

SELECT TABLE_CATALOG ,
        TABLE_SCHEMA ,
        TABLE_NAME ,
        TABLE_TYPE
FROM INFORMATION_SCHEMA.TABLES

SELECT * FROM sys.Tables;

Should do the magic :-D

And if u want to see all columns, i would do

SELECT TOP 1 * From Tablename;

so u'll get one row with all Columns, its not perfect but it does the trick if u just want to know sth

Related