Hi All, I need to create a table structure based on below datas Role Config Project Student Data Reoprt Admin true false false true PM false false true true 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

you can use bit for boolean. CREATE TABLE Persons ( Role varchar(50), config bit, Project bit, StudentData bit, Report bit );

CREATE TABLE Person ( Role varchar(30), config boolean, Project boolean, StudentData boolean, Report boolean );

Answers

Create Table based on Below Data

siva nathan

780

1 SQL Server

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