本文介绍了如何从数据库中获取表脚本的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
Hii，
我们如何在Sybase中从数据库中获取表脚本。
谢谢提前。
Hii,
How can we Take Table Scripts from database in Sybase.
thank you in advance.
推荐答案
SELECT [object_id], [name], [column_id] FROM sys.columns WHERE [object_id] > 99 ORDER BY [name]
字段类别中的其他候选项，用于表重构，不太可能被scriptor所知（你，数据库复印机）：
Other candidates in the field category, to be used for table reconstruction, less likely to be known by the "scriptor" (you, the database copier):
[system_type_id]
[user_type_id]
[max_length]
[precision]
[scale]
[collation_name]
[is ................ (etc)]
[xml_collection_id]
[default_object_id]
[rule_object_id]
重点是程序员必须使用一些TSQL重建表格：
The point being that the programmer will have to reconstruct the tables using some TSQL:
CREATE TABLE ....
基于他对Sybase实例的了解。
Based upon his knowledge of the Sybase instance.
这篇关于如何从数据库中获取表脚本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！