answersLogoWhite

0


Best Answer

Trying to look at the Schema, how can I do that Different database servers use different commands to look at a schema. Additionally, the client software that you use has features that make it easier to manipulate database objects.

MS SQL Server

sp_help

lists all tables in a schema

sp_help [tablename]

displays information for table [tablename]

Oracle

select table_name from sys.user_tables

list all tables for the current schema

select t.* from sys.user_tab_columns t

list all tables, columns, and data types for the current schema

There are entire websites dedicated to database programming. Windows Active Directory I believe this question is referring to the Active Directory schema, in which case, adsiedit.exe is a good place to start. Please follow this link for more info: http://technet.microsoft.com/en-us/library/cc757747.aspx#w2k3tr_schem_tools_dzid option to view the schema register schmmgmt.dll using this command c:\windows\system32>regsvr32 schmmgmt.dll Open mmc --> add snapin --> add Active directory schema name it as schema.msc Open administrative tool --> schema.msc

User Avatar

Wiki User

15y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

14y ago

Windows Active Directory I believe this question is referring to the Active Directory schema, in which case, adsiedit.exe is a good place to start. option to view the schema register schmmgmt.dll using this command c:\windows\system32>regsvr32 schmmgmt.dll Open mmc --> add snapin --> add Active directory schema name it as schema.msc Open administrative tool --> schema.msc

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: HOW to look at the Schema in AD how can you do that?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Which holds writable copy of AD schema?

Schema Master


How can you look at the active directory schema?

To view AD Schema, Firstly you need to register dll Start-run- regsvr32 c:\winnt\system32\schmmgmt.dll and Enter.Where you will find a pop up message succeeded. start - run - mmc-Enter where you can see mmc console1-Go to file and click on Add/remove snap in - click on Add and select the AD Schema from the menu and save mmc console in which ever name u wanted to. Obviously, It will work only on Domain Controller and schema admins only have the rights to do changes on AD schema. Subhash.


What is the schema in AD?

The schema is the Active Directory component that defines all the objects and attributes that the directory service uses to store data.


How would you prepare the AD Schema in advance before installing Exchange?

Part of the Exchange installation is to run ForestPrep. ForestPrep extends the AD schema by adding Exchange-specific properties. If you just start the Exchange setup, it guides you right through this step.


What does an Operating system schema look like?

j


Is it possible to restore active directory windows 2003 to windows 2008 server?

No, you cannot restore AD from 2003 to 2008 directly. You need to upgrade the AD infrastructure to 2008 (schema update).


What is star flake schema?

A starflake schema is a combination of a star schema and a snowflake schema. Starflake schemas are snowflake schemas where only some of the dimension tables have been denormalized. hardkingofflirt@gmail.com


What is schema and sub-schema?

The schema is the physical arrangement of the data as it appears in the DBMS. The subschema is the logical view of the data as it appears to the application program.


Explain the three schema architecture of DBMS?

Physical schema,logical schema and sub schemas


What part of speech is the word schema?

Schema is a noun.


What is schema in mysql?

Schema is structure you created for your tables in My SQL


Why do you need mapping between schema levels?

There is need for mappings between schema levels for visualization and schema matching. The mappings between schema levels helps in the different types of transformation.