数据库表名最大长度(Oracle=30;SqlServer=128;)

1.Oracle 数据库 (支持30个字符)

--30个字符
CREATE TABLE Tab_Test1234567890abcdefghijkl(
       ts int
);

--select * from Tab_Test1234567890abcdefghijkl;
--Drop table Tab_Test1234567890abcdefghijkl;

创建成功;

--31个字符
CREATE TABLE Tab_Test1234567890abcdefghijklm(
       ts int
);

创建失败

2.Sql Server数据库(支持128个字符)

--   >128个字符
CREATE TABLE Tab_Test1234567890abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ000000000000000000000000000000000000000000000000001111111111111111111111111111110
(
       ts int
);

原文地址:https://www.cnblogs.com/wangfuyou/p/5979776.html