============

 SQL Server

============

.. contents::

   :local:

Informational schema

====================

::

  SELECT * FROM sys.tables;

  SELECT * FROM sys.views;

  SELECT * FROM sys.indexes;

  SELECT * FROM information_schema.tables;

Table stats

===========

Individual table::

  EXEC sp_spaceused NAME;

All tables in a schema::

  sp_msforeachtable 'EXEC sp_spaceused [?]';

List collations

===============

::

  SELECT name, description FROM sys.fn_helpcollations();