摘要:
[sql] view plaincopyprint?--sampledatatotestPostgreSQLINFORMATION_SCHEMA --TABLETEST CREATETABLETEST(TEST_NAMECHAR(30)NOTNULL,TEST_IDINTEGERDEFAULT'0'NOTNULL,TEST_DATETIMESTAMPNOTNULL);ALTERTABLETESTADDCONSTRAINTPK_TESTPRIMARYKEY(TEST_ID);--TABLETEST2withsomeCONSTRAINTsandanINDEX CREATETABLE 阅读全文