Nagappan

;; This buffer is for notes you don't want to save, and for Lisp evaluation.
;; If you want to create a file, visit that file with C-x C-f,
;; then enter the text in that file's own buffer.

row = restrictionTable.NewRow();

row["CollectionName"] = "IndexColumns";
row["RestrictionName"] = "ConstraintName";
row["ParameterName"] = "@ConstraintName";
row["RestrictionDefault"] = "x.name";
row["RestrictionNumber"] = 4;

row = restrictionTable.NewRow();

row["CollectionName"] = "IndexColumns";
row["RestrictionName"] = "Column";
row["ParameterName"] = "@Column";
row["RestrictionDefault"] = "c.name";
row["RestrictionNumber"] = 5;

row = restrictionTable.NewRow();

row["CollectionName"] = "Indexes";
row["RestrictionName"] = "Catalog";
row["ParameterName"] = "@Catalog";
row["RestrictionDefault"] = "db_name()";
row["RestrictionNumber"] = 1;

row = restrictionTable.NewRow();

row["CollectionName"] = "Indexes";
row["RestrictionName"] = "Owner";
row["ParameterName"] = "@Owner";
row["RestrictionDefault"] = "user_name()";
row["RestrictionNumber"] = 2;

row = restrictionTable.NewRow();

row["CollectionName"] = "Indexes";
row["RestrictionName"] = "Table";
row["ParameterName"] = "@Table";
row["RestrictionDefault"] = "o.name";
row["RestrictionNumber"] = 3;

row = restrictionTable.NewRow();

row["CollectionName"] = "Indexes";
row["RestrictionName"] = "Name";
row["ParameterName"] = "@Name";
row["RestrictionDefault"] = "x.name";
row["RestrictionNumber"] = 4;

row = restrictionTable.NewRow();

row["CollectionName"] = "UserDefinedTypes";
row["RestrictionName"] = "assembly_name";
row["ParameterName"] = "@AssemblyName";
row["RestrictionDefault"] = "assemblies.name";
row["RestrictionNumber"] = 1;

row = restrictionTable.NewRow();

row["CollectionName"] = "UserDefinedTypes";
row["RestrictionName"] = "udt_name";
row["ParameterName"] = "@UDTName";
row["RestrictionDefault"] = "types.assembly_class";
row["RestrictionNumber"] = 2;

row = restrictionTable.NewRow();

row["CollectionName"] = "ForeignKeys";
row["RestrictionName"] = "Catalog";
row["ParameterName"] = "@Catalog";
row["RestrictionDefault"] = "CONSTRAINT_CATALOG";
row["RestrictionNumber"] = 1;

row = restrictionTable.NewRow();

row["CollectionName"] = "ForeignKeys";
row["RestrictionName"] = "Owner";
row["ParameterName"] = "@Owner";
row["RestrictionDefault"] = "CONSTRAINT_SCHEMA";
row["RestrictionNumber"] = 2;

row = restrictionTable.NewRow();

row["CollectionName"] = "ForeignKeys";
row["RestrictionName"] = "Table";
row["ParameterName"] = "@Table";
row["RestrictionDefault"] = "TABLE_NAME";
row["RestrictionNumber"] = 3;

row = restrictionTable.NewRow();

row["CollectionName"] = "ForeignKeys";
row["RestrictionName"] = "Name";
row["ParameterName"] = "@Name";
row["RestrictionDefault"] = "CONSTRAINT_NAME";
row["RestrictionNumber"] = 4;