6 March 2015

Find Column Names From Table in SQL Server

Select Column_Name
From INFORMATION_SCHEMA.COLUMNS
Where TABLE_NAME='CustomerOrderDetails'


Id
ExportLicenseNumber
CustomerOrderId
RepairSerialNumber
IsInitialQuote
Revision
CODate
COReceiptDate
PriorityCodeOfCustomer
CustomerRefNumber
CustomerRefDefinition
OrderFromCustomerId
DeliverToCustomerId
ResponsibleLocationId
DeliveryPoint
DeliveryTerms
PaymentTerms
ShipmentViaSupplierId
OtherCommentsAndSpecialInstructions
CurrencyId
LeadTime
LeadTimeUOM
QuoteTypeId
QuotePriceType
ExpectedDeliveryDate
EstimatedDeliveryDate
PartialShipmentAllowed
ShippingAndHandlingPrice
ShippingAndHandlingPriceUSD
OtherChargesType
OtherCharges
OtherChargesUSD
OtherCharges1
OtherCharges1USD
OtherCharges1Type
IncountryTransportation
IncountryTransportationUSD
Insurance
TaxPercentage
DiscountUSD
Discount
ItemReferenceNumber
ReferenceNumber
PartId
PartConditionId
SupplierPartNumber
Quantity
Price
PriceUSD
IsItemClosed
CustomerOrderNotes
OrderFromCustomerAddressId
OrderFromcustomerPOCId
CustomerAddressId
CustomerPOCId
DeliverToAddressId
DeliverToPOCId
SalesExportLicenceRequired
RepairExportLicenceRequired
ExportLicenseTypeId
ItemDecremented
DSP
ExportLicenseCategoriesId
ExportToCountryId
EndUserCountryId
EndUserCustomerId
CFR1234a
CFR1234b
DSP61
WarrantyRequirement
CustomerRefOrderNumber
IsArchived
COCreationDate
CustomerOrderItemNote
DeclaredCustomsValueoftheGoodbyCustomer

5 March 2015