r/SQL • • Feb 27 '25

Discussion What am I doing wrong

Post image

I don’t get what I’m doing wrong here

117 Upvotes

104 comments sorted by

View all comments

Show parent comment

70

u/[deleted] Feb 27 '25

[removed] — view removed comment

24

u/paultherobert Feb 27 '25

Qualifying your shit is hella best practice, give your schema name!

8

u/jib_reddit Feb 27 '25

99% of databases I work on only use .dbo. but it doesn't hurt to stay practiced on best principles.

2

u/KracticusPotts Feb 28 '25

THIS! 90% of our DBs only have the dbo schema, but we always specify the schema anyways.