+1
Started

Index a column using the icon, and toggle option like primary key, unique key etc

Bradley Dalina 6 years ago updated by Support 6 years ago 1

When creating new table all the columns by default is set to primary key, I was clicking on the key icon, I thought I can click it and toggle options  that allows to un-index other column but not.


And hope it has another additional options in the column null/not-null toggle 

that can set default value or defined value as (defined, none, null, not-null) 


But this is a great Application!


Thank you!

Answer

Answer
Started

To change PrimaryKey to Non-PrimaryKey or vice versa, all you need to do is: move/drag the column above or below line as shown in following help link. (FYI: All columns above line are PKs)


https://support.sqldbm.com/knowledge-bases/2/articles/13-how-to-movecopysortorder-columns


Following screenshot shows horizontal line separating PK and Non PK columns:


Answer
Started

To change PrimaryKey to Non-PrimaryKey or vice versa, all you need to do is: move/drag the column above or below line as shown in following help link. (FYI: All columns above line are PKs)


https://support.sqldbm.com/knowledge-bases/2/articles/13-how-to-movecopysortorder-columns


Following screenshot shows horizontal line separating PK and Non PK columns: