All Columns from user tables and views
This script lists the columns with type and length. It eliminates system tables.
2001-12-13
749 reads
List all primary keys
Thanks to Raul Sharma for his brilliant ideas. This is a modification of one of his scripts. The script takes only the user tables. Those tables which does not have PK are not listed!
2001-12-13
718 reads
Blogs
Pluralsight Free April
By Gail Shaw
It’s a few days into April, but not too late I hope to mention...
Daily Coping 7 Apr 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
Reading a SharePoint List with Azure Logic App
Sometimes in life you have to do things you really don’t like to do....
Forums
Understanding and Improving Query Plans
Hi everyone. I have a process that is taking a long time to execute...
Daily Coping Tip 7 Apr 2020
Daily Coping Tip: Rediscover your favourite music that really lifts your spirits. My thoughts:...
Developer Edition
I am proposing to the business that we use SQL 2019 Developer in our...
Ask SSC