Loading

Create Table based on Below Data

siva nathan

5y900

Hi All,

I need to create a table structure based on below datas

need to show above screen in Front end config,Project,Student Data and Reports are screen names

in future no of screen may increase and Role also be increase

Need to create a Table structure for this

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Aman Gupta5y ago
CREATE TABLE Person ( Role varchar(30), config boolean, Project boolean, StudentData boolean, Report boolean );
0
Sachin Singh5y ago
you can use bit for boolean.
CREATE TABLE Persons (

    Role varchar(50),
    config bit,
    Project bit,
    StudentData bit,
    Report bit
);
+1