============
 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();