sql=[sp_help "tInvoiceDetail" ] tInvoiceDetail|dbo|user table|May 10 2005 02:25PM| ID|int|no|4|10|0|no|(n/a)|(n/a)|| InvoiceID|int|no|4|10|0|yes|(n/a)|(n/a)|| BatchTypeID|int|no|4|10|0|yes|(n/a)|(n/a)|| Period|varchar|no|7|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS| CentreID|int|no|4|10|0|yes|(n/a)|(n/a)|| ActivityID|int|no|4|10|0|yes|(n/a)|(n/a)|| ElementID|int|no|4|10|0|yes|(n/a)|(n/a)|| AmountExGST|money|no|8|19|4|yes|(n/a)|(n/a)|| GSTAmount|money|no|8|19|4|yes|(n/a)|(n/a)|| BatchID|int|no|4|10|0|yes|(n/a)|(n/a)|| Description|varchar|no|100|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS| CreditNoteInvoiceDetailID|int|no|4|10|0|yes|(n/a)|(n/a)|| CreditNotePeriod|varchar|no|7|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS| SubledgerID|int|no|4|10|0|yes|(n/a)|(n/a)|| ID| 1.000000| 1.000000|0| No rowguidcol column defined.| PRIMARY| IX_tInvoiceDetail|nonclustered located on PRIMARY|InvoiceID| IX_tInvoiceDetail_1|nonclustered located on PRIMARY|BatchTypeID| IX_tInvoiceDetail_2|nonclustered located on PRIMARY|Period| PK_tInvoiceDetail|clustered, unique, primary key located on PRIMARY|ID| PRIMARY KEY (clustered)|PK_tInvoiceDetail|(n/a)|(n/a)|(n/a)|(n/a)|ID| No foreign keys reference table 'tInvoiceDetail', or you do not have permissions on referencing tables. No views with schema binding reference table 'tInvoiceDetail'.