1.define the structures the databases and tables.
record column =
colName :: string
colType :: datatype
record table =
tableName :: string
columns :: "column list"
primaryKey :: "string list"
constraints :: "constraint list"
record database =
dbName :: string
tables :: "table list"
2.define the sql syntax in the basis of 1.
I want the general idea .
New contributor
mumu Hu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.