Export table structure on Sql server 2008
来源:互联网 发布:指弹中国淘宝店 编辑:程序博客网 时间:2024/04/27 12:55
I just tried the first one, it works
1. Create a script of the table's definition.
From Management Studio in Object Explorer, right-click the table and point to Script Table as and then select Create to and choose to save it to a file.
or for SQL Server 2000
From Query Analyzer, right-click the table and select Script Object to File as and then select Create.
2. Use sp_help.
From either Management Studio or Query Analyzer run the following statement.
EXEC sp_help ('your_table_name')
3. Create a database diagram.
See Books Online topics for creating database diagrams. (although your print options are somewhat limited with this).
http://social.msdn.microsoft.com/Forums/en-US/sqldocumentation/thread/f124a182-7e31-410c-a27b-b3cb9072f5e3/
- Export table structure on Sql server 2008
- Export table data sql scrpit on sql server 2008
- An example to show how to make Tree structure data table in SQL server
- VBS Get Sql Server Table Data and Export to CSV File...
- SQL Server 2008-建立分区表(Table Partition)
- SQL Server 2008-建立分区表(Table Partition)
- SQL Server 2008-建立分区表(Table Partition)
- SQL Server 2008-建立分区表(Table Partition)
- SQL Server 2008-建立分区表(Table Partition)
- SQL Server 2008 alter table column type
- SQL Server 2008-建立分区表(Table Partition)
- SQL Server Temporary Table
- SQL Server -- ALTER TABLE
- Export data from SQL Server to Excel
- Export IIS Log to SQL Server
- SQL Server Table Schema SQL
- Get XML tree format based on the tree data in SQL server table
- Temporary Tables vs. Table Variables and Their Effect on SQL Server Performance
- BIND 从服务器及缓存服务器配置
- C# Study
- 逆波兰式(后缀表达式)的运用-计算四则表达式并用lex,Yacc拓展
- oracle 数据格式化
- Java中的四舍五入 保留指定位小数
- Export table structure on Sql server 2008
- 项目研发管理实施经验谈(1)
- 法语简历
- MemSQL架构 - 快速(MVCC,InMem,LockFree的CodeGen),和熟悉
- 操作系统真实的虚拟内存是什么样的(二:Windows下内存限制)
- Android开发2——创建测试项目
- 51定时器中断程序编写 [李园7舍_404]
- c++builder 汇编
- ARP协议的基础知识(经典)