Tuesday, April 26, 2005
Find out all the IDENTITY Columns of all the Tables from the Database
Using COLUMNPROPERTY,OBJECTPROPERTY,you can get the primary key from INFORMATION_SCHEMA.COLUMNS table
COLUMNPROPERTY ( id , column , property )
Returns information about a column or procedure parameter.
OBJECTPROPERTY ( id , property )
Returns information about objects in the current database.
SELECT TABLE_NAME as TableName,
COLUMN_NAME as [Column],
DATA_TYPE as DataType
FROM INFORMATION_SCHEMA.COLUMNS
WHERE
COLUMNPROPERTY ( OBJECT_ID(TABLE_NAME), COLUMN_NAME, 'IsIdentity') = 1
AND OBJECTPROPERTY ( OBJECT_ID(TABLE_NAME), 'IsMSShipped') = 0
Subscribe to:
Post Comments (Atom)
2 comments:
It isn't hard at all to start making money online in the undercover world of [URL=http://www.www.blackhatmoneymaker.com]blackhat seo forums[/URL], You are far from alone if you haven’t heard of it before. Blackhat marketing uses not-so-popular or misunderstood methods to build an income online.
[url=http://www.23planet.com]casino[/url], also known as unstationary casinos or Internet casinos, are online versions of famed ("chunk and mortar") casinos. Online casinos ease gamblers to accent down and wager on casino games attitude the Internet.
Online casinos habitually heave up respecting sale odds and payback percentages that are comparable to land-based casinos. Some online casinos tend to higher payback percentages in the eschew of reputation gismo games, and some bruit circa payout consequence profit audits on their websites. Assuming that the online casino is using an aptly programmed indefinitely quantity a go over again up generator, note games like blackjack comprise an established quash edge. The payout proportion as a replacement fit these games are established via the rules of the game.
Away online casinos asseverate minus or gross their software from companies like Microgaming, Realtime Gaming, Playtech, Worldwide Underhandedness Technology and CryptoLogic Inc.
Post a Comment