我试图删除sqlite列上的UNIQUE约束,但我没有删除约束的名称.如何找到UNIQUE约束名称的名称以将其删除.
下面是我在表中看到的模式,我想删除约束
UNIQUE(datasource_name)
sqlite> .schema datasources CREATE TABLE "datasources" ( created_on DATETIME NOT NULL,changed_on DATETIME NOT NULL,id INTEGER NOT NULL,datasource_name VARCHAR(255),is_featured BOOLEAN,is_hidden BOOLEAN,description TEXT,default_endpoint TEXT,user_id INTEGER,cluster_name VARCHAR(250),created_by_fk INTEGER,changed_by_fk INTEGER,"offset" INTEGER,cache_timeout INTEGER,perm VARCHAR(1000),filter_select_enabled BOOLEAN,params VARCHAR(1000),PRIMARY KEY (id),CHECK (is_featured IN (0,1)),CHECK (is_hidden IN (0,FOREIGN KEY(created_by_fk) REFERENCES ab_user (id),FOREIGN KEY(changed_by_fk) REFERENCES ab_user (id),FOREIGN KEY(cluster_name) REFERENCES clusters (cluster_name),UNIQUE (datasource_name),FOREIGN KEY(user_id) REFERENCES ab_user (id) );
