>SQL serverda kullanışlı bazı View vs SP ler

>Kullanımı : SSMS de query window da SELECT * FROM VIEW_NAME
ornek : SELECT * FROM sys.databases

sys.databases
sys.tables
sys.views
sys.procedures
sys.triggers
sys.columns
sys.syscolumns
sys.key_constraints
sys.check_constraints
sys.default_constraints
sys.foreign_keys
sys.syslogins
sys.sql_logins
sys.sysusers

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s