CUBRID Study Notes 19 SQL statement 1, cubrid Study Notes

CUBRID Study Notes 19 SQL statement 1, cubrid Study Notes

Create

You are welcome to reprint it. Please keep the author's information during reprinting. This article copyright belongs to me, if you have any questions, please contact me wang2650@sohu.com. Fault

 

Create table tableName (field Name field type primary key

)


Delete

Drop table if exists tableName;

Whether the table exists

Select count (*) from db_class where class_name = 'tablename'

TableName should be in lower case

Rename a table

Rename table oldname to newname