Question

Create the following table.

Column name	Data type	Size	Constraints
Scode	Integer	3	Primary key
Sname	Varchar	20
Place	Varchar	10

Answer 1

CREATE TABLE Streams (
    Scode INTEGER(3) PRIMARY KEY,
    Sname VARCHAR(20),
    Place VARCHAR(10)
);