sql=[sp_help "tServiceID" ] tServiceID|dbo|user table|May 10 2005 02:25:10:607PM| ID|int|no|4|10|0|no|(n/a)|(n/a)|| ServiceID|varchar|no|50| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS| Service|varchar|no|50| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS| ServiceTypeID|int|no|4|10|0|yes|(n/a)|(n/a)|| SACCnumber|varchar|no|50| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS| Description|varchar|no|70| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS| SupplierAccountID|int|no|4|10|0|yes|(n/a)|(n/a)|| CustomerCentreID|int|no|4|10|0|yes|(n/a)|(n/a)|| CustomerActivityID|int|no|4|10|0|yes|(n/a)|(n/a)|| CustomerElementID|int|no|4|10|0|yes|(n/a)|(n/a)|| CustomerSubLedgerID|int|no|4|10|0|yes|(n/a)|(n/a)|| 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)|| SubledgerID|int|no|4|10|0|yes|(n/a)|(n/a)|| LocationID|int|no|4|10|0|yes|(n/a)|(n/a)|| CurrentRent|money|no|8|19|4|yes|(n/a)|(n/a)|| CurrentCalls|money|no|8|19|4|yes|(n/a)|(n/a)|| PreviousRent|money|no|8|19|4|yes|(n/a)|(n/a)|| PreviousCalls|money|no|8|19|4|yes|(n/a)|(n/a)|| InstallationDate|datetime|no|8| | |yes|(n/a)|(n/a)|| TerminationDate|datetime|no|8| | |yes|(n/a)|(n/a)|| PersonID|int|no|4|10|0|yes|(n/a)|(n/a)|| UpEnd|varchar|no|23| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS| UpFrameID|int|no|4|10|0|yes|(n/a)|(n/a)|| UpMDF|varchar|no|6| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS| DownEnd|varchar|no|23| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS| DnFrameID|int|no|4|10|0|yes|(n/a)|(n/a)|| DownMDF|varchar|no|6| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS| Length|float|no|8|53||yes|(n/a)|(n/a)|| No|varchar|no|7| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS| Part|varchar|no|2| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS| ServiceCode|nvarchar|no|120| | |yes|(n/a)|(n/a)|SQL_Latin1_General_CP1_CI_AS| JobNo|varchar|no|10| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS| BearerID|int|no|4|10|0|yes|(n/a)|(n/a)|| SpeedID|int|no|4|10|0|yes|(n/a)|(n/a)|| Drawing|varchar|no|10| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS| ModemTypeID|int|no|4|10|0|yes|(n/a)|(n/a)|| Cost|float|no|8|53||yes|(n/a)|(n/a)|| Cost100|float|no|8|53||yes|(n/a)|(n/a)|| Make|varchar|no|12| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS| Ch|float|no|8|53||yes|(n/a)|(n/a)|| Mux|varchar|no|7| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS| LineID|int|no|4|10|0|yes|(n/a)|(n/a)|| StartTerminalID|int|no|4|10|0|yes|(n/a)|(n/a)|| StatusID|int|no|4|10|0|yes|(n/a)|(n/a)|| Active|bit|no|1| | |yes|(n/a)|(n/a)|| PayType|varchar|no|2| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS| DateEntered|datetime|no|8| | |yes|(n/a)|(n/a)|| DateLastChanged|datetime|no|8| | |yes|(n/a)|(n/a)|| LastUpdatedBy|varchar|no|50| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS| Invoiced|float|no|8|53||yes|(n/a)|(n/a)|| TelcoID|int|no|4|10|0|yes|(n/a)|(n/a)|| ApplicationID|int|no|4|10|0|yes|(n/a)|(n/a)|| AuthorityID|int|no|4|10|0|yes|(n/a)|(n/a)|| VirtualCableID|int|no|4|10|0|yes|(n/a)|(n/a)|| MUXLink|nvarchar|no|30| | |yes|(n/a)|(n/a)|SQL_Latin1_General_CP1_CI_AS| ServiceLink|nvarchar|no|20| | |yes|(n/a)|(n/a)|SQL_Latin1_General_CP1_CI_AS| ServiceMnemonicID|int|no|4|10|0|yes|(n/a)|(n/a)|| ServiceKpiID|int|no|4|10|0|yes|(n/a)|(n/a)|| ID| 1.000000| 1.000000|0| No rowguidcol column defined.| PRIMARY| IX_tServiceID|nonclustered located on PRIMARY|ServiceTypeID| IX_tServiceID_1|nonclustered located on PRIMARY|CustomerElementID| IXtServiceID_ServiceID|nonclustered located on PRIMARY|ServiceID| PK_tServiceID|clustered, unique, primary key located on PRIMARY|ID| PRIMARY KEY (clustered)|PK_tServiceID|(n/a)|(n/a)|(n/a)|(n/a)|ID| No foreign keys reference table 'tServiceID', or you do not have permissions on referencing tables. No views with schema binding reference table 'tServiceID'.