Comandes útils per mssql server

/*EXPLAIN*/
sp_help nomTaula
GO


/*SHOW tables*/
SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
GO