How do I determine if a column is an identity column in MSSQL 2000?
You can also do it this way: select columnproperty(object_id(‘mytable’),’mycolumn’,’IsIdentity’) Returns 1 if it’s an identity, 0 if not.
metadata
Sqlite: adding COMMENT ON descriptions to tables and columns?
I don’t think it does. The “SQL As Understood By SQLite” page makes no mention of table or column comments nor does the CREATE TABLE or ALTER TABLE documentation. Also, the Unsupported SQL wiki page has this: 2009-08-04: Table and column comments – I have scoured the doco and can’t find anything about applying comments … Read more
Stringify template arguments
You could try typeid(T).name() Edit: Fixed based on comments.
nuget retrieving package metadata
It requires two steps (second is maybe optional, but I always like clean solution) In Explorer open folder where your project resides. Open packages.config using Notepad. Find and remove the line that mentions corrupted package name. Open folder where your solution resides. Open subfolder “packages”. Find folder with corrupted package and remove it. Note: If … Read more
Reading the PDF properties/metadata in Python
Try pdfminer: from pdfminer.pdfparser import PDFParser from pdfminer.pdfdocument import PDFDocument fp = open(‘diveintopython.pdf’, ‘rb’) parser = PDFParser(fp) doc = PDFDocument(parser) print(doc.info) # The “Info” metadata Here’s the output: >>> [{‘CreationDate’: ‘D:20040520151901-0500’, ‘Creator’: ‘DocBook XSL Stylesheets V1.52.2’, ‘Keywords’: ‘Python, Dive Into Python, tutorial, object-oriented, programming, documentation, book, free’, ‘Producer’: ‘htmldoc 1.8.23 Copyright 1997-2002 Easy Software Products, … Read more
What does ‘git commit’ mean when it says ‘create mode …’ on stdout?
For more information about Git’s mode, see this answer. Git’s ability to store file metadata is limited to a simple subset of information to allow Git to track some basic file system changes allowing Git to track relevant changes for source code management; such as whether a file has been modified and whether a file … Read more
SQL Server: should I use information_schema tables over sys tables?
Unless you are writing an application which you know for a fact will need to be portable or you only want quite basic information I would just default to using the proprietary SQL Server system views to begin with. The Information_Schema views only show objects that are compatible with the SQL-92 standard. This means there … Read more
Can I add metadata to git commits? Or can I hide some tags in gitk
Git-notes With git notes you can add a “note” to a commit. You can also add them to other Git objects, but let’s just focus on commits since that is what the question is about. A note is a Git object, and can in principle be “whatever” (arbitrary data). But we’ll focus on something simple … Read more
Get the unique constraint columns list (in TSQL)?
Ed is correct, the columns are exposed on the constraint column usage view, here is the SQL for it. select TC.Constraint_Name, CC.Column_Name from information_schema.table_constraints TC inner join information_schema.constraint_column_usage CC on TC.Constraint_Name = CC.Constraint_Name where TC.constraint_type=”Unique” order by TC.Constraint_Name