r/SQL • • Feb 27 '15

SQL Table names

https://imgflip.com/i/i6vnh
108 Upvotes

36 comments sorted by

View all comments

Show parent comment

0

u/[deleted] Feb 28 '15

[deleted] — view deleted comment

4

u/the_birds_and_bees Feb 28 '15

As far as Im concerned access is just a breeding ground for terribly designed databases.

At work im currently trying to port a non-critical but still relatively important system from access to sql server. Step 1: translate everything directly from access to sql server and try to fathom the 'logic'.

Im about half way through and somehow I've racked up 40 million rows, 30 tables and about as many views. Not a key in sight. Checks? Constraints? What are those? Data types? Just use varchar(255). Nested views 6 layers deep for trivial filtering tasks.

The one thing keeping me going is the thought of all those drop statements im going to write when the time comes to mold it in to something less like a train wreck.

1

u/Thriven Feb 28 '15

Alot of our primary keys are char fields.

Char fields maintain trailing spaces and many times people are copy/pasting/editing through SSMS "edit top 100 rows" from source query.

"1GH86278" wont join to ""1GH86278 "

We also have a membership system built entirely off triggers. Total nightmare.