Vv-mssql-shared NPM

Install & Use

npm i vv-mssql-shared

const vvms = require('vv-mssql-shared')

let script_create_or_alter_table = vvms.depot_sch_table('dbo', 'table1', 'my table #1', [
    {name: 'fld1', description: 'field #1 - primary key', type: 'int', identity: true, pk_position: 1},
    {name: 'fld2', description: 'field #2', type: 'bit'},
    {name: 'fld3', description: 'field #3', type: 'nvarchar', len_chars: 100},
    {name: 'fld4', description: 'field #4', type: 'nvarchar', len_chars: 'max'},
    {name: 'fld5', description: 'field #5', type: 'decimal', precision: 14, scale: 3}
], 'ignore')
console.log(script_create_or_alter_table)

Typedefs

sqltype : 'bigint' | 'bit' | 'decimal' | 'int' | 'money' | 'numeric' | 'smallint' | 'smallmoney' | 'tinyint' | 'float' | 'real' | 'date' | 'datetime2' | 'datetime' | 'datetimeoffset' | 'smalldatetime' | 'time' | 'char' | 'text' | 'varchar' | 'sysname' | 'nchar' | 'ntext' | 'nvarchar' | 'binary' | 'image' | 'varbinary' | 'hierarchyid' | 'sql_variant' | 'xml' | 'uniqueidentifier' | 'timestamp' | 'geometry' | 'geography'

MS SQL datatype

Kind: global typedef

type_sql_object_name : s.type_sql_object_name

Kind: global typedef

type_column

MS SQL tables column

Kind: global typedef
Properties

Name	Type
name	string
type	sqltype
len_chars	number \| 'max'
precision	number
scale	number
nullable	boolean
identity_seed	number
identity_increment	number
pk_position	number
description	string
collate	string

type_sql

MS SQL datatype params

Kind: global typedef
Properties

Name	Type
precision	'deny' \| 'allow' \| number
scale	'deny' \| 'allow' \| number
len	'deny' \| 'allow' \| 'deny_max' \| number
jstype	'number' \| 'Date' \| 'string'
xsdtype	'xs:integer' \| 'xs:decimal' \| 'xs:boolean' \| 'xs:date' \| 'xs:dateTime' \| 'xs:time' \| 'xs:string'
bytes_on_char	number
type	sqltype