All pastes #123630 Raw Edit

Nagappan

public text v1 · immutable
·published 2006-08-09 13:15 UTC
rendered paste body
row = getSchemaTable.NewRow()

row["CollectionName"] = "MetaDataCollections";
row["NumberOfRestrictions"] = 0;
row["NumberOfIdentifierParts"] = 0;
getSchemaTable.Rows.Add(row);

row = getSchemaTable.NewRow()

row["CollectionName"] = "DataSourceInformation";
row["NumberOfRestrictions"] = 0;
row["NumberOfIdentifierParts"] = 0;
getSchemaTable.Rows.Add(row);

row = getSchemaTable.NewRow()

row["CollectionName"] = "DataTypes";
row["NumberOfRestrictions"] = 0;
row["NumberOfIdentifierParts"] = 0;
getSchemaTable.Rows.Add(row);

row = getSchemaTable.NewRow()

row["CollectionName"] = "Restrictions";
row["NumberOfRestrictions"] = 0;
row["NumberOfIdentifierParts"] = 0;
getSchemaTable.Rows.Add(row);

row = getSchemaTable.NewRow()

row["CollectionName"] = "ReservedWords";
row["NumberOfRestrictions"] = 0;
row["NumberOfIdentifierParts"] = 0;
getSchemaTable.Rows.Add(row);

row = getSchemaTable.NewRow()

row["CollectionName"] = "Users";
row["NumberOfRestrictions"] = 1;
row["NumberOfIdentifierParts"] = 1;
getSchemaTable.Rows.Add(row);

row = getSchemaTable.NewRow()

row["CollectionName"] = "Databases";
row["NumberOfRestrictions"] = 1;
row["NumberOfIdentifierParts"] = 1;
getSchemaTable.Rows.Add(row);

row = getSchemaTable.NewRow()

row["CollectionName"] = "Tables";
row["NumberOfRestrictions"] = 4;
row["NumberOfIdentifierParts"] = 3;
getSchemaTable.Rows.Add(row);

row = getSchemaTable.NewRow()

row["CollectionName"] = "Columns";
row["NumberOfRestrictions"] = 4;
row["NumberOfIdentifierParts"] = 4;
getSchemaTable.Rows.Add(row);

row = getSchemaTable.NewRow()

row["CollectionName"] = "Views";
row["NumberOfRestrictions"] = 3;
row["NumberOfIdentifierParts"] = 3;
getSchemaTable.Rows.Add(row);

row = getSchemaTable.NewRow()

row["CollectionName"] = "ViewColumns";
row["NumberOfRestrictions"] = 4;
row["NumberOfIdentifierParts"] = 4;
getSchemaTable.Rows.Add(row);

row = getSchemaTable.NewRow()

row["CollectionName"] = "ProcedureParameters";
row["NumberOfRestrictions"] = 4;
row["NumberOfIdentifierParts"] = 1;
getSchemaTable.Rows.Add(row);

row = getSchemaTable.NewRow()

row["CollectionName"] = "Procedures";
row["NumberOfRestrictions"] = 4;
row["NumberOfIdentifierParts"] = 3;
getSchemaTable.Rows.Add(row);

row = getSchemaTable.NewRow()

row["CollectionName"] = "ForeignKeys";
row["NumberOfRestrictions"] = 4;
row["NumberOfIdentifierParts"] = 3;
getSchemaTable.Rows.Add(row);

row = getSchemaTable.NewRow()

row["CollectionName"] = "IndexColumns";
row["NumberOfRestrictions"] = 5;
row["NumberOfIdentifierParts"] = 4;
getSchemaTable.Rows.Add(row);

row = getSchemaTable.NewRow()

row["CollectionName"] = "Indexes";
row["NumberOfRestrictions"] = 4;
row["NumberOfIdentifierParts"] = 3;
getSchemaTable.Rows.Add(row);

row = getSchemaTable.NewRow()

row["CollectionName"] = "UserDefinedTypes";
row["NumberOfRestrictions"] = 2;
row["NumberOfIdentifierParts"] = 1;
getSchemaTable.Rows.Add(row);