SQWareRepository:mssql

From Wiki_dbSQWare
Revision as of 19:04, 8 August 2015 by Expdbtools (talk | contribs) (Replaced content with '{{SQWareRepositoryPresSgbd|Mssql|database|alias FreeTds|msq}} == Specific database content for Mssql ==')
Jump to: navigation, search

Presentation

It is the repository module, and stores rdbms indicators for all RDBMS.
It is a MySQL database.
Objects prefix by tsqw_% or isqw_% are generic.
Objects prefix by tsqwmsq_% or isqwmsq_% are specific for Mssql.
Installation guide for SQWareRepository for Mssql

Naming convention

All specific objects for Mssql are named with prefixes:

  • tsqwmsq_% : for tables
  • isqwmsq_% : for index
  • isqwmsq_%_u : for uniques
  • isqwmsq_%_pk : for primary key


Nuvola apps important.png
Warning:
Do not change the standard tables of the tool. For your custom objects, use another name convention than dbSQWare.

This will facilitate version upgrades.


Specific database content for Mssql

Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareRepository:mssql&oldid=7255"