Топ-100
top of page
logo-cerebrosql

MSSQL_LIST table

The table stores information necessary to connect to MS SQL Server databases.

CREATE TABLE MSSQL_LIST (
     [id]          INTEGER PRIMARY KEY AUTOINCREMENT,
     [alias]       TEXT,
     [groupname]   TEXT,
     [servername]  TEXT,   

     [serverport]  TEXT,

     [dbname]      TEXT,
     [auth]        INTEGER default 0,
     [username]    TEXT,
     [userpasswd]  TEXT,
     [color_page]  TEXT,
     UNIQUE ([alias])

)

Description of table fields

id
record number in the table
alias
synonym for connection. Displayed in connection selection forms. Unique value
groupname
the name of the system to which the MS SQL Server belongs. The value in the field is used to group data in lists
servername
DNS name of the server or its IP address
serverport
the port on which the MS SQL Server DBMS instance is running
auth
authentication method, 0 - domain, 1 - login/password
username
username in the MS SQL Server DBMS under which the connection is made
userpasswd
user password. It is stored in ASCII code due to the peculiarities of storing data in some encodings in SQLite databases
color_page
obsolete
bottom of page