bug in a table creation using smo

Question

I am trying to create a simple table testtable using SQL Server Management Objects (SMO) in a winforms application.

Database db = srv.Databases["model"];
Table t = new Table(db,"testtable");

DataType dt = new DataType(SqlDataType.Int);
Column c = new Column(t, "ID", dt);
c.Nullable = false;
t.Columns.Add(c);

dt = new DataType(SqlDataType.VarChar, 100);
c = new Column(t, "Name", dt);
t.Columns.Add(c);

try
{
    Index i = new Index(t, "PK");
    IndexedColumn ic = new IndexedColumn(i, "ID");
    i.IndexedColumns.Add(ic);
    i.IndexKeyType = IndexKeyType.DriPrimaryKey;
    i.Create();
}
catch (Exception ex)
{
    MessageBox.Show(ex.Message.ToString());
}

but each time it shows

Create failed for Index PK ?

and the code doesn't create any table at the SQL server – May 31 '12 at 12:27 — , May 31 '12 at 12:27

score 0 · Accepted Answer · edited Jun 01 '12 at 15:03

0

i was missing.. table.create().. problem is solved.

edited Jun 01 '12 at 15:03

Peter DeWeese

18,141
8
79
101

answered Jun 01 '12 at 07:44

bug in a table creation using smo

1 Answers1