create table scott.products
时间: 2023-10-03 10:08:51 浏览: 82
Sure, here is the SQL statement to create a table named "products" under the schema "scott":
CREATE TABLE scott.products (
product_id INT NOT NULL,
product_name VARCHAR(50) NOT NULL,
product_desc TEXT,
product_price DECIMAL(10,2),
PRIMARY KEY (product_id)
);
阅读全文