Replicating database objects through c# code

Question

I need to create database objects (table, index, keys, views, functions, etc.) through the c#.net code. The user specifies the name of the database object to be replicated and the new name given to the copied object.

So suppose user selects existing table TableA and the new name TableB, my code should create TableB having the same structure (columns, etc.) as TableA.

I am okay with the actual creation part. I need tips on how to get the TableA metadata (structure).

Which is the best way to achieve the same?

Thanks very much :)

LorenVS · Accepted Answer · 2009-12-03 10:07:26Z

2

Take a look into SQL Management Objects (SMO), its a library developed by microsoft for performing management tasks on SQL server databases through managed code. It includes code to script databases and the objects within them, which should satisfy a large portion of your applications requirements

answered Dec 3, 2009 at 10:07

LorenVS

12.9k10 gold badges49 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Klaus Byskov Pedersen · Accepted Answer · 2009-12-03 10:07:59Z

1

Have a look at a library called SMO (SQL Server Management Objects): http://msdn.microsoft.com/en-us/library/ms162169.aspx

answered Dec 3, 2009 at 10:07

Klaus Byskov Pedersen

122k31 gold badges192 silver badges223 bronze badges

Comments

Razzie · Accepted Answer · 2009-12-03 10:24:56Z

1

You can get this information from the INFORMATION_SCHEMA schema.

For example:

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'TableA'

will give you all the columns. See here for a tutorial.

edited Dec 3, 2009 at 10:24

answered Dec 3, 2009 at 10:10

Razzie

31.3k12 gold badges67 silver badges82 bronze badges

1 Comment

LorenVS Over a year ago

Except that INFORMATION_SCHEMA is a SCHEMA, not a TABLE, "COLUMNS" is the TABLE

Collectives™ on Stack Overflow

Replicating database objects through c# code

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related