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
717 reads
Blogs
Getting Started with SQL Prompt 10
By Steve Jones
This week we released SQL Prompt 10, which is an exciting milestone for us....
Power Platform Quick Tips – Episode 01: Fixing Power BI Column Sorting
By Devin-Knight
Check out this new series that I’ve started on Power Platform Quick Tips. This...
The curious case of CHAR(0)
Over the years I’ve seen quite a few strange things with SQL Server. This...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
Learn from the Troubles of Others
Comments posted to this topic are about the item Learn from the Troubles of...
Help with determining formulas/processes for solving a problem?
Hello all, Looking for all the smart people out there who can hear a...
Ask SSC