I have a csv sheet that is a data dictionary. It looks like this:
TableName PhysicalTableName PrimaryKey ForeignKey ForeignKey FieldName PhysicalFieldName DATATYPE LENGTH
Owner Table OWNER X Lease ID API14 *Owner ID *OWNR_ID VARCHAR 50
Owner Table OWNER Owner ID Lease ID API14 **Lease ID List **LSE_ID_LIST VARCHAR 50
Owner Table OWNER Owner ID Lease ID API14 **API14 List **API14_LIST VARCHAR 50
Owner Table OWNER Lease Count LSE_CNT VARCHAR 50
As you can see, this is not about importing a csv full of data. This is a csv with schema metadata.
I need to know if there's a way in SQL Server to build the tables defined in this csv. There are over 2000 lines in this document.
I'm hoping I don't have to run this manually.
If anyone has any ideas, I'd greatly appreciate it.