How to generate "Create Table" script, when I only have read only permission?

Question

I have read only permission on a SQL Server 2005 database, and I'm looking to get a table schema locally to work with. With my current access it won't let me right click on the table and choose 'Create Table' to get the script for this.

Is there a way to generate the create table script from a select statement or by some other mechanism?

Thank you!

Would you be happy with a solution that just gave columns and datatypes? Actually how do you get on with the script here http://stackoverflow.com/questions/21547/in-sql-server-how-do-i-generate-a-create-table-statement-for-a-given-table/21551#21551 — Martin Smith, Mar 26 '11 at 21:15

score 2 · Answer 1 · edited May 17 '13 at 15:23

2

It's a bit long but the script in Script Table Definitions using TSQL could be addapted to work without needing to create the stored procedure mentioned.

I am assuming you are working with SQL Server 2005

edited May 17 '13 at 15:23

Brad

11,934
4
45
73

answered Mar 26 '11 at 21:18

Lieven Keersmaekers

57,207
13
112
146

score 2 · Accepted Answer · answered Mar 26 '11 at 21:19

You could create a linked server on your local machine. Then, you can use select ... into to copy the table, including data:

select  *
into    NewTableName
from    [LinkedServerName].[DatabaseName].dbo.TableName

This will not copy indexes or constraints. To exclude the data, use select top 0 *.

How to generate "Create Table" script, when I only have read only permission?

2 Answers2