cs122a-2016-spring: createscript.sql

File createscript.sql, 414 bytes (added by waans11, 5 years ago)
Line 
1create schema mytestdb;
2
3use mytestdb;
4/* Your DDL SQL statements should starts after this line */
5CREATE TABLE SINGER
6(SINGER_NAME VARCHAR(50) NOT NULL, SEX CHAR(1) NOT NULL,
7AGE INTEGER NOT NULL,
8PRIMARY KEY (SINGER_NAME)
9);
10/* Your DDL SQL statements end before this line */
11
12use information_schema;
13
14select * from tables where table_schema = 'mytestdb';
15select * from columns where table_schema = 'mytestdb';