All Columns from user tables and views
This script lists the columns with type and length. It eliminates system tables.
2001-12-13
753 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
720 reads
Blogs
Azure SQL Database – Contained user Model
By Arun Sirpal
I always follow a contained user model when setting up users within my Azure...
Logging Messages with Raiserror – #SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Daily Coping 8 Mar 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Wait for query to finish before returning results
When I do "select * from ... " from a large table, the result...
Reading a Specific File from an S3 bucket Using Python
Comments posted to this topic are about the item Reading a Specific File from...
Distributed SQL Databases
Comments posted to this topic are about the item Distributed SQL Databases
Ask SSC