When i wrote a program about database on SQL for setting up a data table ,the compiler showed a error ' there is a mistake near 'drop '' I can't find out the reason for the program isright,the wrriten is right. Please help me slove this problem.
create schema test authorition zhang
create table tab1 (col1 smallint,
col2 int,
col3 char(20),
col4 numberic (10,3)
);
drop schema zhang restrict