Manual

Login

Our 3D CAD supplier models have been moved to 3Dfindit.com, the new visual search engine for 3D CAD, CAE & BIM models.

You can log in there with your existing account of this site.

The content remains free of charge.

Manual

4.11.3.1. Prerequisites 4.11.3.1.1. SQL commands for applying the "Sequencer" table in the LinkDB
Prev	Next

4.11.3.1.1. SQL commands for applying the "Sequencer" table in the LinkDB

4.11.3.1.1.1. CNSSEQ Table

Make sure your PARTsolutions version contains the "Sequencer" table "CNSSEQ". If needed, use the following corresponding command lines.

MSSQL

CREATE TABLE CNSSEQ (
  TOPIC VARCHAR(50) NOT NULL,
  PREFIX VARCHAR(50) NOT NULL,
  COUNTER INTEGER NOT NULL,
PRIMARY KEY(TOPIC,PREFIX,COUNTER)
);
grant all on dbo.CNSSEQ to public;

MySQL

CREATE TABLE CNSSEQ (
  TOPIC VARCHAR(50) NOT NULL,
  PREFIX VARCHAR(50) NOT NULL,
  COUNTER INTEGER NOT NULL,
PRIMARY KEY(TOPIC,PREFIX,COUNTER)
);
grant all on dbo.CNSSEQ to public;

Oracle

CREATE TABLE CNSSEQ (
  TOPIC VARCHAR(50) NOT NULL,
  PREFIX VARCHAR(50) NOT NULL,
  COUNTER INTEGER NOT NULL,
  PRIMARY KEY(TOPIC,PREFIX,COUNTER)
);
CREATE PUBLIC SYNONYM CNSSEQ FOR SYSTEM.CNSSEQ;
GRANT ALL ON CNSSEQ

Prev	Up	Next
4.11.3.1. Prerequisites	Home	4.11.3.1.1.1. CNSSEQ Table

Manual

Login

Top Links

Manual

4.11.3.1.1. SQL commands for applying the "Sequencer" table in the LinkDB